This discussion is archived
1 Reply Latest reply: Mar 5, 2013 11:22 PM by Christian Erlinger RSS

sys_refcursor is closed when transfered to forms

995035 Newbie
Currently Being Moderated
Hi,
I'm using a stored procedure to populate values to sys_refcursor using a dynamic select
open res for MY_CUR_SELECT ....
when it gets to the forms calling that procedure the sys_refcursor is closed.
I know that using an explicit select (open res for select ...) works but I realy need to use a dynamic one.
Thanks a lot, Uri

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points