Re: Call Oracle Stored Proceedure VB.NET

"my_proc"

You also have to ensure the Commands CommandType is set to stored procedure. And, since you are using OracleClient, you need to return a REF_CURSOR and set as an out parameter (which you will never use, go figure). With OleDb, you still have a REF_CURSOR return, but do not have to declare it as a param. Yes, a strange anomaly. Once you have the REF_CURSOR param declared, you simply use the DataSet or Reader as normal with other databases.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*********************************************
Think outside the box!
*********************************************
"Problematic coder" <gnewsham@xxxxxxxxx> wrote in message news:1173393339.727926.218280@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have a form based application that inputs values into various oracle
tables, after it has done this I want to call a stored proceedure in
Oracle which is already written to do more work on this data, it does
not return any values to vb nor does it expect any criteria or input.

I already have a connection to Oracle open using the following code:

Dim objcnn As New Data.OracleClient.OracleConnection(ConnectStr)
Dim objcom As Data.OracleClient.OracleCommand
objcnn.Open()
objcom = New Data.OracleClient.OracleCommand(strSQLinsert, objcnn)
objcom.ExecuteNonQuery()

Assuming the stored proceedure is named "my_proc" could I use a
similar command like:

objcom = New Data.OracleClient.OracleCommand(strCallMyProc, objcnn)

If so what would strCallMyProc = ?

If not how else could I or should I call it?

Thanks


.

Relevant Pages

  • Call Oracle Stored Proceedure VB.NET
    ... I have a form based application that inputs values into various oracle ... Dim objcnn As New Data.OracleClient.OracleConnection ... Dim objcom As Data.OracleClient.OracleCommand ... Assuming the stored proceedure is named "my_proc" could I use a ...
    (microsoft.public.dotnet.framework.aspnet)
  • Call Oracle Stored Proceedure VB.NET
    ... I have a form based application that inputs values into various oracle ... Dim objcnn As New Data.OracleClient.OracleConnection ... Dim objcom As Data.OracleClient.OracleCommand ... Assuming the stored proceedure is named "my_proc" could I use a ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: AIX Performance issue
    ... this is how we take backup ... Same for Oracle 7.3.4? ... application, in this database, on this Operating System? ... Perhaps the scripts and commands you're running ...
    (comp.unix.aix)
  • Re: Quick role test
    ... alter user bob1 default role all except foo33 identified using ... After the combined commands, ... Surely Oracle development tests all sorts of things, ...
    (comp.databases.oracle.server)
  • Re: [SLE] sudoers file
    ... I like it because it logs all commands, ... # This file MUST be edited with the 'visudo' command as root. ... # Oracle user is oracle on some machines, ...
    (SuSE)