Page 1 of 1
How to Oracle stored procedure in ORACLE stage?
Posted: Fri Nov 11, 2005 10:34 am
by RaviM
Could plz help me in calling stored procedure,
How to Oracle stored procedure in ORACLE stage?
Posted: Fri Nov 11, 2005 10:59 pm
by rleishman
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;)
Posted: Sat Nov 12, 2005 2:01 am
by arunverma
Another way to call procedure with PL/SQL / Insert /Update etc .
== First create procedure in Oracle database .
== Create shell script which connect oracle and execute procedure
== Call this shell script from DS Jobs with Before/After job subrouite ( ExecSH) .
Regards
Arun