RE: I want to use oracle stored procedure

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Hylton (Hylton_at_discussions.microsoft.com)
Date: 12/01/04 

Date: Wed, 1 Dec 2004 01:09:06 -0800

Have a look at
http://otl.sourceforge.net/home.htm
for the Oracle Template Library. Open source but makes running stored procs
on oracle a breaze

"John Paul. A" wrote:

> Hi Sezhman,
> Go through this Microsoft KB : 309361 "How To Use a DataReader Against an
> Oracle Stored Procedure in Visual C# .NET"
> http://support.microsoft.com/default.aspx?scid=kb;en-us;309361
>
> Rgds,
> John Paul. A
>
>
>
> "Sezhman" wrote:
>
> > I am using Oracle Database, Can anyone tell me, how to connect to the oracle
> > database and run the stored procedure in oracle.
> > I am facing some problem in this. please guide me..
> > --
> > Sezhman

Relevant Pages

  • Re: Error in calling stored procedure via DB link
    ... "Paul Clement" wrote: ... Below is an Oracle KB article that documents the issue. ... Calling Stored Procedure over Dblink Using Oracle OleDb Provider Fails ... > symptom: Using command type adCmdStoredProc ...
    (microsoft.public.vb.database.ado)
  • Re: Performance problems with StoredProcedure in Web application
    ... you could probably just ignore my comments about stored procedure performance as compared to textual queries because they ... As for your question about how to avoid using a cursor (as I suggested was possible in Oracle) read the following paragraph for more ... The .NET Framework Data Provider for Oracle does not support batched SQL statements. ... CURSOR output parameters to fill a DataSet, ...
    (microsoft.public.dotnet.languages.csharp)
  • 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: EXEC syntax for SP which returns row set
    ... >>> Oracle experts, none of whom seem to know. ... >> SQL> create or replace package returncur is ... > I don't know why you are supplying the above example. ... to illustrate HOW you'd call a stored procedure and return ...
    (comp.databases.oracle.server)
  • 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)