Any Way to use DBMS_SQL with a Ref Cursor?

The only efficient way to get large amounts of data into a PowerBuilder datawindow (via a stored procedure) is to use a procedure that takes an in/out ref cursor parameter. I'd really like to do this and have the select statement (really just the where clause) built dynamically in a string. The result set for a given stored procedure would always be fixed and known at compile time. So far, I can't find any way to make it work. Is there any way I could do this with DBMS_SQL? I have often been amazed at things I can do with Oracle that I would never have guessed from looking at the documentation and am hoping this will be another one.

Thanks for any ideas,

Gene Hubert
Qualex Inc.
Durham, NC Received on Tue Apr 06 1999 - 21:34:33 CDT