Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> oracle and asp.net

oracle and asp.net

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


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US