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
Using weak ref cursors is not supported in forms. If you need to use dynamic SQL you have the option of the exec_sql package or using a record group (search the forum and/or the documentation for samples on both).
Or of course you could put your whole logic with the ref cursor in a stored procedure.