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

    sys_refcursor is closed when transfered to forms

      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