Error executting Stored procedure using Microsoft Oracle managed p

[Chetan]

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

[guy]

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

"Chetan" wrote:

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