1. Stored Procedures Returning a Cursor coderanch.com |
2. Returning Cursor from Stored Procedure coderanch.comThis 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 ... |
3. how to call a stored procedure which return cursor coderanch.com |
4. can we directly use cursor in jdbc code with out using procedure coderanch.com |
5. does a procedure returns cursor, if so, how to hadle that in java coderanch.com |
6. Call Stored Procedure Returning Cursor as Output coderanch.comHi 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.comHi, 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 ... |