oracle and asp.net

From: EstCstFlp <m_oblena_at_hotmail.com>
Date: 18 Mar 2003 12:19:29 -0800
Message-ID: <9bf53fa8.0303181219.490c460e_at_posting.google.com>

[Quoted] 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 - 21:19:29 CET