Re: Calling a pl/sql procedure from SQLPLUS in HP UNIX`

use a shell script and a sql file like this:

in the shell script place the following text:

passwd=$1
sqlplus OracleSchemaName//$passwd
_at_/directory/of/the/sql/script/NameOfSQLFile.sql

in the sql file place the following text:

exec NameOfPL/SQLPackage.ProcedureName;
exit

You can then call the shell script passing in the password as a parameter or set it up to run as a cron job

"Dina Ghatit" <dghatit_at_nortelnetworks.com> wrote in message news:9drub6$2rh$1_at_bcarh8ab.ca.nortel.com...
> I'm using execute function in sqlplus and it is not working.
>
> sqlplus << EOF
> sapadm/sapadm2001_at_fwdev
> VARIABLE id NUMBER
> execute-
> :id := SAPADM. SAP_I0040_WIP_QTY_BALANCE;
> echo 'id' >> filename
>
> Can you help?
>
>
Received on Fri May 18 2001 - 18:46:48 CEST