Hi all,
Within my shell script I am trying to assign the result of a resultset
to a procedure thus
table myuser
ID email username
01 [EMAIL PROTECTED] trub3101
02 [EMAIL PROTECTED] rtub3102
remove_myuser.ksh
#!/bin/ksh
sqlplus /nolog<<EOF
connect myself/myself
var num_var number
begin
select id into :num_var from myuser where email = '[EMAIL PROTECTED]';
end;
/
exec remove_myuser_rec(num_var) ; --- Which is suppose represent exec
remove_myuser_rec(01)
exit
EOF
For some reason or another this does not work. I keep getting this
error:
SQL> SQL> BEGIN remove_myuser_rec(num_var); END;
*
ERROR at line 1:
ORA-06550: line 1, column 22:
PLS-00201: identifier 'NUM_VAR' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Would any kind soul out there be able to explain why this is not
working?
Many thanks in advance,
tb3101
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
