Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Calling PL/SQL procedure from sqlplus
> sqlplus -s sapadm/sapadm2001<<EOF
> VARIABLE id NUMBER;
> BEGIN
> :id := SAPADM.SAP_I0040_WIP_QTY_BALANCE;
> END;
What about a DECLARE?
Try this:
sqlplus -s sapadm/sapadm2001<<EOF
DECLARE
VARIABLE id NUMBER;
BEGIN
:id := SAPADM.SAP_I0040_WIP_QTY_BALANCE;
END;
Regards,
Knut Received on Wed May 16 2001 - 07:22:14 CDT