Re: Looking for command to execute database procedure

In article <918lgd$6dn$1_at_nnrp1.deja.com>,   anasuya_shukla_at_my-deja.com wrote:
> Hi ,
>
> Is there anyway to run an Oracle database procedure on
> a Unix box without invoking SQLPlus ?
> I want to execute this procedure in a shell script.
>
> Thanks
>
> Ana
>
> Sent via Deja.com
> http://www.deja.com/
>

You must execute SQL within some sort of environment. The simplist one is SQLPlus which can be executed from within a shell, with appropriate arguements / files. Read up on running scripts from files in SQLPlus.

Similarly, you could run SQL in other environments like perl and C/C++ and tcl. There require more coding and organization, but can prove a more robust response to queries. Of course these can be called from within a shell.

--
Michael Krolewski
Rosetta Inpharmatics
mkrolewski_at_rosetta.org
              Ususual disclaimers


Sent via Deja.com
http://www.deja.com/