Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Calling PL/SQL procedure from sqlplus

Calling PL/SQL procedure from sqlplus

From: Dina Ghatit <dghatit_at_nortelnetworks.com>
Date: Wed, 16 May 2001 08:03:04 -0400
Message-ID: <9dtqbp$7oh$1@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 - 07:03:04 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US