Re: Calling Oracle Stored Procedure from Shell Script

From: Dmitry E. Loginov <lde_at_mpsb.ru>
Date: Fri, 24 Jun 2005 10:48:48 +0400
Message-ID: <d9gaa7$1tbs$1@news.caravan.ru>

<beenamore_at_gmail.com> wrote in message
news:1119595116.117457.322180_at_g14g2000cwa.googlegroups.com...
> Hi,
>
> I have a stored procedure proc1(param1 in varchar2, param2 in
> varchar2). I have tested this one and it works fine.
>
> I need to call this procedure from a shell script. I am using
>
> sqlplus -S ${ORACLE_USER}/${ORACLE_PASSWORD}@${ORACLE_CONN}
> @${INSTALL_ROOT}proc.sql
>
> and proc.sql is
> begin
> exceute proc1('param1','param2');
> end;
>

Just add EXIT command to end of the proc.sql file.

> When I execute the above, the shell script just hangs. Can anyone tell
> me the correct way of calling a stored procedure from sh program?
>
> Thanks for your help,
> Beena
>
Received on Fri Jun 24 2005 - 01:48:48 CDT