Tags » Ref Cursor

another day passed – another ORA-600 hit :-)

Sometimes I feel as if I attracted more of the dreaded ORA-600/ORA-3113 exceptions than other people around me. :-) Yesterday, my node.js colleague, trying to fetch some data I was preparing for him within a stored procedure and returning via… 716 more words

Oracle DB

How to access REF CURSOR Data in Java ?

In Java, a REF CURSOR is known as a ResultSet object and can be accessed as shown below:

import oracle.jdbc.*;
...
CallableStatement cstmt;
ResultSet cursor;

// Use a PL/SQL block to open the cursor
cstmt = conn.prepareCall
         ("begin open ?
126 more words

Java