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

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