returning value from a PL/SQL block.
412601Jan 21 2004 — edited Aug 11 2004Hi,
Is it possible to execute a PL/SQL block which returns a varchar2. I dont use stored procedures. I am trying to do it in 8.1.7. Like this
declare res number; begin select empno into res from emp where ename='SMITH'; delete from emp where empno=res; end t1;
It is executing and deleting the record but it gives
java.sql.SQLException: ORA-00600: internal error code, arguments: [12259], [], [], [], [], [], [], []
My intention is getting a concatenated string.
rgds
Antony Paul