Re: Passing Back Table Information from Oracle .NET Stored Procedures


<jehugaleahsa@xxxxxxxxx> wrote in message news:1185809768.963317.39600@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
You are still not understanding my question. I am not trying to call a
stored procedure, not in the typical PL/SQL sense. Okay, it is
possible to upload a .NET assembly to an Oracle database. In doing so,
the database engine can execute the .NET assembly under a context. In
a sense, you are executing a .NET assembly just like you would any
other PL/SQL stored procedure.

This is not PL/SQL. I am not trying to get a ref cursor. I am trying
to get the results of a select command from a ".NET stored procedure".
Check out this link if you have no clue what I am talking about:
http://www.oracle.com/technology/pub/articles/mastering_dotnet_oracle/williams_sps.html.

If you take the time to look at the link, you will know exactly what I
am talking about. All the example links I have been shown have been
for working with ADO .NET or writing PL/SQL. I just want to get a
result set from a .NET stored procedure. And, yes, it *is*, really,
truly, a .NET stored procedure.

So? Even in the example you are providing, it's returning a result set. I don't care if it's MS SQL in-line code or Oracle in-line code, MS SQL Server, Oracle Proc, or this so called .NET Stored Procedure using a Select statement, they are all returning a RESULT SET whether it be one row or multiple rows.

You put the RDR into a loop until it hits EOF and read the data in the result set, row by row.

CountryName = rdr.GetString(0); // in the example is CountryName field on the row.

Or CountryName = rdr.GetString("CountryName"); // or something like that.

In either of above the cases, you must use a DATAREADER to read the rows and address the fields on the rows of a returned result set.


.

Relevant Pages

  • Re: Passing Back Table Information from Oracle .NET Stored Procedures
    ... stored procedure, not in the typical PL/SQL sense. ... I don't care if it's MS SQL in-line code or Oracle in-line code, MS SQL Server, Oracle Proc, or this so called .NET Stored Procedure using a Select statement, they are all returning a RESULT SET whether it be one row or multiple rows. ... I used SqlContext above because I don't want to bother registering at the Oracle site to download their Oracle Database Extensions for .NET in order to get at the presumably extant OracleContext class. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: inserting XML Document into Oracle database using a stored procedure
    ... What i am trying to do is i want to insert a xml file into the Oracle database using a stored procedure which takes a XmlType type parameter. ...
    (perl.dbi.users)
  • Re: Oracle Stored Procedures with Enterprise Library June 2005 Version
    ... Try to stick to ANSI SQL than PL/SQL for your Oracle is safe. ... Oracle Stored Procedure using the Enterprise Library June 2005 ... CREATE OR REPLACE PACKAGE SelectPackage AS ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: EXEC syntax for SP which returns row set
    ... you'd call a stored procedure and return data using an OUT parameter. ... I admit that I am new to Oracle stored procedures, ... > I was testing the SP in SQL*Plus not PL/SQL. ... > java program ...
    (comp.databases.oracle.server)
  • Re: Passing Back Table Information from Oracle .NET Stored Procedures
    ... stored procedure, not in the typical PL/SQL sense. ... the database engine can execute the .NET assembly under a context. ...
    (microsoft.public.dotnet.languages.csharp)