1 Reply Latest reply: Mar 6, 2013 1:22 AM by Christian Erlinger RSS

    sys_refcursor is closed when transfered to forms

    995035
      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