Re: Calling PLSQL from a batch file

It is possible to do this in Unix, invoking sqlplus with a PL/SQL code as input parameter. In this PL/SQL you send the standard output to a file, and use the dbms_output package to write in the file. You can then, from the unix batch file, parse the output file to retrieve the result (using, sed / awk / ...).

I hope this helps

"John Donoghue" <donoghuejohn_at_lineone.net> wrote in message news:8j21na$bcr$1_at_supernews.com...
> I have a requirement to automate some scripts produced by an ETL tool via
> batch file(s). Does anyone know how I can call a PL/SQL API from a
> batchfile, sending some parameters and retrieving a resultant parameter.
> Have thought that Qbasic may be able to do this but have had no success as
> yet.
>
> Will be sending information about each script to the API and the API
 returns
> a value representing Success or Failure of each script.
>
> I know we could have used the scheduler of the ETL tool but the client has
> ruled this method out.
>
> Suggestions appreciated,
> JD
>
>
>
>
>
Received on Mon Jun 26 2000 - 00:00:00 CDT