Re: oracle and asp.net

On 18 Mar 2003 12:19:29 -0800, m_oblena_at_hotmail.com (EstCstFlp) wrote:

You did not say what driver you were using. The default .NET oledb driver? The Microsoft Oracle Provider for DOTNET or the Oracle Provider for .NET.

You could will probably need to create a SQLREADER object and read it into a string string array and then bind to the data grid using the databind method. THe microsoft web site has some examples of calling Oracle from .DOTNET. Also, reference the latest oramag.com manuals.

ASP.NET and ADO.NET can be pesky.

>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 - 19:15:42 CST