Top "Sys-refcursor" questions

A predefined Oracle cursor variable type.

Best way to check if SYS_REFCURSOR is empty

I have a cursor with values from a select and i want to do something after depending if i had …

sql oracle plsql sys-refcursor
how to declare %ROWTYPE of a variable that is a weakly typed SYS_REFCURSOR?

W.r.t code below I can not declare the type of fetch-into-variable as the underlying table's %ROWTYPE because the …

oracle stored-procedures plsql sys-refcursor rowtype
Ref cursor with Execute immediate

I want to get the results in ref_cursor, but I am not able to do that. Please suggest me …

sql oracle plsql sys-refcursor execute-immediate
Oracle: How to populate/insert row to a Ref Cursor?

Really need help regarding Ref Cursor. I have a Stored Procedure GET_PERSONROLES that have parameter type ref cursor. I …

oracle plsql sys-refcursor
JPA and SYS_REFCURSOR like OUT parameter

I want to call a procedure using JPA with SYS_REFCURSOR like OUT parameter. This is very easy using plain …

java plsql eclipselink sys-refcursor glassfish-4
How to close a returning cursor in PL/SQL?

I am new to PL/SQL and I just got to cursors in my learning process. I've been seeing stored …

oracle plsql sys-refcursor ref-cursor
Using ouput parameter of type SYS_refcursor

In my database I have a stored procedure with an OUTPUT parameter of type SYS_REFCURSOR. The application side is …

c# stored-procedures oracle10g out-parameters sys-refcursor
How to use jmeter to test an Oracle Stored Procedure with sys_refcursor return type?

I want to test an Oracle Stored Procedure by using jmeter.I have done everything but parameters. And here is …

oracle testing stored-procedures jmeter sys-refcursor