Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> URGENT !! How do I pass a parameter to this script ??
I have the following script and would like it to take the $parm value as the &1 parameter. How can I do this ?
parm='aaa'
ORA_LOGIN=uid/pwd
sqlplus -s $ORA_LOGIN << EOF read RtnCode
set serverout on size 2000;
DECLARE
RC VARCHAR2(10) DEFAULT NULL;
BEGIN
RC := '&1'; -- &1 should be = $parm DBMS_OUTPUT.PUT_LINE(RC);
TIA
Das
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Jun 13 2000 - 00:00:00 CDT