Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

returning value from a PL/SQL block.

412601Jan 21 2004 — edited Aug 11 2004
Hi,
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 8 2004
Added on Jan 21 2004
6 comments
5,584 views