procedure « Cursor « Java Database Q&A





1. Stored Procedures Returning a Cursor    coderanch.com

2. Returning Cursor from Stored Procedure    coderanch.com

This seems to be a common problem and I have done it in the past but cannot for the life of me remember how I did it. I have a simple stored procedure which does a select statement and needs to send me the resultset back. I've got a cursor set up and when I run it through the sqlplus it ...

6. Call Stored Procedure Returning Cursor as Output    coderanch.com

Hi i am trying to call a stored procedure that returns ref cursor as out parameter but i am getting null pointer Exception suggest me where am i doing wrong Stored Procedure create or replace PROCEDURE SP_PDC_TEST_5(p_CustomerID IN CHAR DEFAULT NULL,p_rpt_cursor OUT cr_package.cr_cursor) IS --p_Firstname varchar(255); BEGIN OPEN p_rpt_cursor FOR SELECT acct_id from ci_acct_per where per_id=p_CustomerID; END; My Servlet code Snippet ...

7. Cursors in a procedure    coderanch.com

8. Calling procedure that returns cursor AND other data    coderanch.com

Hi, I need to implement a call to a procedure via JDBC that returns a cursor and some other data. The output of the procedure looks like this: {Varchar2 v, Cursor c {Varchar v, Number n}, Intreger i} - My first question is, what is the correct way to call the procedure. I know that the input is varchar and the ...