Re: procedure execute on unix

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:19:24 CDT