Could plz help me in calling stored procedure,
How to Oracle stored procedure in ORACLE stage?
How to Oracle stored procedure in ORACLE stage?
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 252
- Joined: Mon Sep 19, 2005 10:28 pm
- Location: Melbourne, Australia
- Contact:
If you just want to call a procedure in the before/after-SQL, then you use the syntax:
You can call many procs this way in the same before/after-SQL, just remember to put a double-semi-colon after each.
You CANNOT call an anonymous PL/SQL block (eg. BEGIN ... END;)
Code: Select all
call procname(params);;
You CANNOT call an anonymous PL/SQL block (eg. BEGIN ... END;)
Ross Leishman