Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: procedure execute on unix
Thank you for your help.
I am not sure what I need to declare, and please help me with this. I have a procedure that is working on win based sqlplus, which is without declare clause, and it is starting from "create or replace procedure A..."
Very appreciated.
<miaemp_at_my-deja.com> wrote in message news:8s1ls7$2v4$1_at_nnrp1.deja.com...
> In a unix script, try the following:
>
> sqlplus <username/password/ << EOI
> Whenever SQLERROR exit failure;
>
> Declare
> -- put any declares here needed
> Begin
> procedureA(......)
> Exception
> when others then
> --Exception handling.
> End;
>
> EOI
>
> Basically, you need to do an anonymous PL/SQL block in a call to SQLPlus
>
> HTH
> EP
> Note that the views expressed here are solely my own and not that of my
> employer's
>
> In article <8s0852$630a$1_at_newssvr05-en0.news.prodigy.com>,
> "Steve" <schen_at_prodigy.net> wrote:
> >
> > Hi,
> >
> > Does someone know how to execute a procedure on unix platform, i.e.
using
> > sqlplus on unix?
> >
> > I had problem such as not declare.
> >
> > Thanks,
> >
> > Steve
> >
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Oct 11 2000 - 07:47:48 CDT