|
-
Mar 27th, 2003, 03:33 PM
#1
Thread Starter
New Member
Calling Oracle stored procedure- error
-Using .Net managed provider for Oracle.
I am trying to call an Oracle stored procedure with 2 in parameters and 1 out parameter.
I am getting an error at the point - mobjCmd.ExecuteNonQuery()
------------------------------------------------------------
An unhandled exception of type 'System.Data.OracleClient.OracleException' occurred in system.data.oracleclient.dll
Additional information: System error.
------------------------------------------------------------
Any help is appreciated!
Here is the code frag-
------------------------------
mobjCmd = New OracleCommand()
mstrConexion.Open()
mobjCmd.Connection = mstrConexion
mobjCmd.CommandText = "SP_UPDATE_INDUSTRY_CLASS"
mobjCmd.CommandType = CommandType.StoredProcedure
mobjCmd.Parameters.Add(New OracleParameter("pSicCode", OracleType.VarChar)).Value = strCode
mobjCmd.Parameters.Add(New OracleParameter("pSicDescription", OracleType.VarChar)).Value = strDescription
mobjCmd.Parameters.Add(New OracleParameter("pSuccess", OracleType.VarChar, 1)).Direction = ParameterDirection.Output
mobjCmd.ExecuteNonQuery()
strUpdateSuccess = mobjCmd.Parameters(2).Value
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|