How to call Oracle stored proc from vb.net app?

[bnathvbdotnet]

I know it is different way to call Oracle stored procedure when compared to SQL server stored proc.

I am using currently the following format to call sql proc (BTW I am using Microsoft DATA access block )

"calling sqlserver stored proc"

helper = GetAdoHelper()
sConn = GetConnectionString()
drsql = helper.ExecuteReader(sConn, CommandType.StoredProcedure, "GetCustomers")


"How to call Oracle stored Proc"??

any help is greatly appreciated

[techgnome]

Unfortunatly the MS Data Access block was designed specifically for SQL Server and uses the SQLData objects. To use Oracle, you will either need to use the OLEDB namespace, or see if there is an Oracle-specific .NET driver.

TG

[bnathvbdotnet]

http://www.gotdotnet.com/Community/W...c-aaeb21d1f431

but, I don't know how to use it to use stored procs in oracle .

thanks

[nemaroller]

Right-click on your Project... Add Reference...

(Make sure .Net is tab shown)

Browse to System.Data.OracleClient

Click OK

Dim OrcConnection1 As New System.Data.OracleClient.OracleConnection("yourconnectionstring")
        Dim OrcCommand1 As New System.Data.OracleClient.OracleCommand
 
 
        OrcCommand1.CommandType = CommandType.StoredProcedure
        OrcCommand1.CommandText = "nameofyourprocedure"
        OrcCommand1.Connection = OrcConnection1
 
        Dim myreader As System.Data.OracleClient.OracleDataReader
        myreader = OrcCommand1.ExecuteReader(CommandBehavior.CloseConnection)
 
        While myreader.Read
            'do whatever
        End While
 
        myreader.Close()

[bnathvbdotnet]

I guess your code works if we are calling sqlserver but not oracle.

nath

[nemaroller]

It works fine... if you wanted a parameter, simply add it:

OrcCommand1.Parameters.Add(New OracleParameter("@fkReadTheHElp", System.Data.OracleClient.OracleType.Int32))
OrcCommand1.Parameters(0).Value = 1

Seriously, just Use the Help ... it has all the information you need...

[bnathvbdotnet]

I will try .

regards
nath