Returning recordsets from stored procedures to ASP?

Hello folks,

I've written a demo app where the ASP client connects to an Oracle 8i database through ADO/ODBC. The client executes SQL SELECT statements on the tables of the database, which returns recordsets to the client, just as one would expect.

The problem is that I want to get rid of explicit knowledge of the database from the client. The easiest way to do this, I figure, IS to move the SELECTS into stored procedures in the database. I've created those stored procs and I'm able to call them from the client. The problem is that I can't get the stored procedures to return the recordsets!? How does one do that in PL/SQL!? I come from an MSQL environment, and there it is really easy.

Please help me, I'm really stuck on this one!

regards

Jonas Received on Thu Feb 17 2000 - 00:00:00 CST