Hi,
I am seeking a way to return a recordset from a stored procedure, like as a simple query might return one (or SQL Server might). The recordset returned will ultimately be used to populate a Crystal Report. An associate had suggested I use cursors and packages, but I am not familiar with those objects. A coded example would be great - perhaps in the form of a simple select from a few joined tables? Thanks.
I am seeking a way to return a recordset from a stored procedure, like as a simple query might return one (or SQL Server might). The recordset returned will ultimately be used to populate a Crystal Report. An associate had suggested I use cursors and packages, but I am not familiar with those objects. A coded example would be great - perhaps in the form of a simple select from a few joined tables? Thanks.
