How to Oracle stored procedure in ORACLE stage?

[RaviM]

Could plz help me in calling stored procedure,
How to Oracle stored procedure in ORACLE stage?

[rleishman]

If you just want to call a procedure in the before/after-SQL, then you use the syntax:

Code: Select all

call procname(params);;

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;)

[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