REFCURSOR
From: Emil <chorvat_at_inmail.sk>
Date: Fri, 1 Feb 2002 10:50:54 +0100
Message-ID: <a3doem$kid$1_at_news.telecom.sk>
Hi,
I want to create Form with one block, data source type is Procedure, return type is IN/OUT REFCURSOR .
I fill name of procedure and parameters. In procedure I use OPEN c_linka FOR l_select using variable , where l_select is dynamic SQL .
But form doesn't work.
When I use OPEN c_linka FOR SELECT .. FROM .. , it is OK. If I need to use dynamic sql, what have I to do?
Date: Fri, 1 Feb 2002 10:50:54 +0100
Message-ID: <a3doem$kid$1_at_news.telecom.sk>
Hi,
I want to create Form with one block, data source type is Procedure, return type is IN/OUT REFCURSOR .
I fill name of procedure and parameters. In procedure I use OPEN c_linka FOR l_select using variable , where l_select is dynamic SQL .
But form doesn't work.
When I use OPEN c_linka FOR SELECT .. FROM .. , it is OK. If I need to use dynamic sql, what have I to do?
Thanks.
Emil Received on Fri Feb 01 2002 - 10:50:54 CET