Re: Looking for command to execute database procedure

Ana,

maybe this is not what you want but you can run sqlplus from a shell script fi that solves your problem e.g.

#! /bin/ksh
.........
.........
sqlplus system/manager << EOF
execute my_proc
exit
EOF
..............
..............

the << EOF tells the shell to keep executing commands until you hit EOF so you can execute the above commands within sqlplus and then EOF terminates the section. you can continue executing shell commands afterwards

rgds
brian

"R. Steven Brown" <rstevenbrown_at_earthlink.net> wrote in message news:qbP16.14035$RC1.336569_at_newsread1.prod.itd.earthlink.net...
> You can use an Oracle language pre-compiler, such as Pro-C, SQLJ (my
> favorite) or you can use PERL with the DatabaseAccess module. There may be
> others. I like SQLJ because it uses java, which is ubiquitous on most Unix
> machines, and it take just a little programming knowledge to embed a call
 to
> a stored procedure.
>
> Steve Brown
> Senior Oracle DBA
> sbrown_at_itiweb.com
>
> <anasuya_shukla_at_my-deja.com> wrote in message
> news:918lgd$6dn$1_at_nnrp1.deja.com...
> > 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/
> >
>
>
Received on Wed Dec 27 2000 - 05:02:51 CST