Error executting Stored procedure using Microsoft Oracle managed p

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi We have Oracle 8.1.7.4 and
using .net framework 1.1 with Microsoft client.
While executting the stored procedure we are getting an error message.
Here is our code.

here is the code that executes the Stored procedure.

Dim connstr As String
Dim conn As OracleConnection
Dim comm As New OracleCommand
Dim dr As OracleDataReader

connstr = "XXXXX"
conn = New OracleConnection(connstr)


Try
comm.Connection = conn
comm.CommandText = "CPATEL.SP_TEST"
comm.CommandType = CommandType.StoredProcedure
comm.Parameters.Add("userid", OracleType.Number).Value = 12
comm.Parameters("userid").Direction = ParameterDirection.Input

conn.Open()
comm.ExecuteNonQuery()
Label1.Text = "Success"
Catch ex As OracleException
Label1.Text = ex.Message
End Try



Here is the simple stored procedure.

PROCEDURE SP_TEST ( uuserid in number)

IS

-- MODIFICATION HISTORY
-- Person Date Comments
-- --------- ------ -------------------------------------------

-- YWC 7/25/01 change null amount to zero
BEGIN
-- error_ind is used to indicate exception error.
-- Do some processing.

EXCEPTION
WHEN OTHERS THEN
NULL ;
END; -- Procedure NVL_TO_ZERO

I am getting following error message.



ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments
in call
to 'SP_TEST' ORA-06550: line 1, column 7: PL/SQL: Statement ignored
 
parameter mismatch?
calling it is userid
in the sp it is uuserid
(an extra u)

is this a typo in the post or in your sp?

hth

guy
 
Back
Top