RE: I want to use oracle stored procedure

From: John Paul. A (JohnPaulA_at_discussions.microsoft.com)
Date: 11/29/04 

Date: Sun, 28 Nov 2004 21:37:02 -0800

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: Extended Stored Procedure: Get the current db of the client
    ... with the caveat that you don't recommend it because Microsoft ... of a stored procedure versus umpteen of the same stored procedure spread ... I am not going after Gert Sue. ... the database context as a parameter if you need it, ...
    (microsoft.public.sqlserver.odbc)
  • Trying to set up a SQL Server Agent Account and I hit a wall....
    ... Our database is on SQL Server 2005, however it is set to compatibility mode ... You may need to set the compatibility level ... of the current database to a higher value to enable this feature. ... for the stored procedure sp_dbcmptlevel. ...
    (microsoft.public.sqlserver.security)
  • Re: Extended Stored Procedure: Get the current db of the client
    ... I am not going after Gert Sue. ... the database context as a parameter if you need it, ... Did you ever write an extended stored procedure? ... different than an extended stored procedure, so that is not giving you want ...
    (microsoft.public.sqlserver.odbc)
  • Re: Extended Stored Procedure: Get the current db of the client
    ... Thanks for the link Sue. ... I am not going after Gert Sue. ... the database context as a parameter if you need it, ... Did you ever write an extended stored procedure? ...
    (microsoft.public.sqlserver.odbc)
  • Re: using sp_ as a naming convention for stored procedures
    ... System stored procedures are created and stored in the master ... database and have the sp_ prefix. ... from any database without having to qualify the stored procedure name fully ... SQL Server always looks for a stored procedure ...
    (microsoft.public.sqlserver.programming)