Re: Call Oracle Stored Proceedure VB.NET

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thank you for answering my question, however I am having a hard time
understanding your answer though undoubtably correct.

I am not familiar with the term REF_CURSOR, I assume what you are
saying is I have to return something whether I need it or not?

I do not want anybody to do my work for me but it might be helpful if
somebody could post some example code which would call the proceedure,
make it run and return a value if that is necessary

Again I appreciate your time

On Mar 8, 8:45 pm, "Cowboy \(Gregory A. Beamer\)"
<NoSpamMgbwo...@xxxxxxxxxxxxxxxxxx> wrote:
"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" <gnews...@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- Hide quoted text -

- Show quoted text -


.