I have written a procedure that returns me Ref cursor.
the object that i am returning is a table of records that have two columns. Both the record and the table is created permanently in db.
I am calling the procedure from
java.
The procedure when run separately, gives me two rows with value.
Now when i take a result set of the cursor, and if i give rs.getInt(column name) it gives me an invalid column index.
But the resultset meta data gives me the information that there are two columns.
So now i am stuck as where to debug.
Can anybody help me out
Thanks in advance