"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@gmail.comwrote in message
news:1173393339.727926.218280@v33g2000cwv.googlegr oups.com...
Quote:
>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
>
