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 -> Call PL/SQL procedure from sqlplus on HP Unix

Call PL/SQL procedure from sqlplus on HP Unix

From: Dina Ghatit <dghatit_at_nortelnetworks.com>
Date: Tue, 15 May 2001 14:57:29 -0400
Message-ID: <9dru7a$2pt$1@bcarh8ab.ca.nortel.com> 






I'm trying to call an pl/sql procedure from sqlplus on HP unix.



I try the execute command


sqlplus << EOF


sapadm/sapadm2001_at_fwdev


VARIABLE id NUMBER


execute-


:id := SAPADM. SAP_I0040_WIP_QTY_BALANCE;
echo 'id' >> file



It does not work?


Can anyone help?
Received on Tue May 15 2001 - 13:57:29 CDT












Original text of this message













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