Re: Calling PL/SQL procedure from sqlplus

In article <9dtqbp$7oh$1_at_bcarh8ab.ca.nortel.com>, Dina Ghatit <dghatit_at_nortelnetworks.com> writes:
>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.
>

I am not very experienced at writing shell scripts but something like this: seqdev 17 % cat mark4.ksh
#!/bin/ksh
sqlplus -s sefin/sefin <<EOF
variable id number
 BEGIN
   :id := 22;
 END;
/
print id
EOF
seqdev 18 % mark4.ksh >>testout
seqdev 19 % cat testout

PL/SQL procedure successfully completed.

        ID

        22

• Mark D Powell --
  • Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net