Re: from a stored procedure to Forms4.5, Passing query results

richard_at_ascada.demon.co.uk wrote:
>
> To improve performance i have moved a dynamically generated query
> from Forms4.5 to a stored procedure. this way the parsed query will be
> loaded into the SGA and only the variables in the 'where' clause need be
> filled with new params on subsequent calls.
>
> Now i have a results table of 14 columns and an average of 100 rows.
> How can i get this information from the stored procedure into a record
> group in Forms without dropping the session ??
>
> votes on wether or not you believe this to be possible are also of
> interest !
>
> cheers,
> richard,.
>
> richard_at_ascada.demon.co.uk
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet

You can use dbms_pipe to pass it to the d2k session. You may be able to use refereced cursors to, but I haven't tackled that yet, so don't know exactly how to it would be implemented.

-- 
"Came for the party, left on the run"

Robert Christenson
Gazette Technologies
robertoc#spam~be~gone#@fyiowa.infi.net