Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> oracle and asp.net
Can I get an example of retreiving a result set from oracle into a
DataGrid in ASP.NET? I'm referencing System.Data.OracleClient. I have
a package and procedure that looks like this:
CREATE OR REPLACE PACKAGE ss_result_set
IS
TYPE RefCursor_ IS REF CURSOR;
END ss_result_set;
CREATE OR REPLACE PROCEDURE ss_return_result_set
(
result_ IN OUT ss_result_set.RefCursor_
)
AS
BEGIN
OPEN result_ FOR
SELECT *
FROM customer_info;
END ss_return_result_set;
TIA, Mike Received on Tue Mar 18 2003 - 14:19:29 CST