Re: Calling PL/SQL procedure from sqlplus

From: Dina Ghatit <dghatit_at_nortelnetworks.com>
Date: Wed, 16 May 2001 13:14:13 -0400
Message-ID: <9ducii$9ni$1@bcarh8ab.ca.nortel.com>

I got it working.
I creted two files, one that set oracle env variables and called antoher file.
The other file was the sqlplus stuff.

Thanks for your help everyone! :o)
Dina Ghatit <dghatit_at_nortelnetworks.com> wrote in message news:9dtqbp$7oh$1_at_bcarh8ab.ca.nortel.com...
> Hi,
> I've tried this and it does not work.
>
> #!/bin/csh -f
> touch /FWORKS/home/fwdev/sap_sql/sapcron/testcron
> export ORACLE_SID=fwdev
> echo "before call" >> /FWORKS/home/fwdev/sap_sql/sapcron/testcron
> function foo
> {
> sqlplus -s sapadm/sapadm2001<<EOF
> VARIABLE id NUMBER;
> BEGIN
> :id := SAPADM.SAP_I0040_WIP_QTY_BALANCE;
> END;
> /
> print id
> EOF
> }
> echo "after function" >> /FWORKS/home/fwdev/sap_sql/sapcron/testcron
> foo >> /FWORKS/home/fwdev/sap_sql/sapcron/testcron
>
> Any ideas?
> Thanks for your help.
>
>
>
Received on Wed May 16 2001 - 12:14:13 CDT