I'm getting this error msg when I run my SP through my app:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'SP_PCMS_APPROVE_CARD' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
is there something wrong with my code or is the problem in the SP?
thanks
VB Code:
Dim objCommand As New OleDbCommand() Try objCommand.Connection = objCon objCommand.CommandText = "SP_PCMS_APPROVE_CARD" objCommand.CommandType = CommandType.StoredProcedure objCommand.Parameters.Add(New OleDbParameter("t_card", OleDbType.Numeric)).Value = cardNo objCommand.Parameters.Add(New OleDbParameter("t_end_date", OleDbType.Date)).Value = tranPeriodEnd objCommand.Parameters.Add(New OleDbParameter("t_error", OleDbType.VarChar, 1)).Direction = ParameterDirection.Output objCon.Open() objCommand.ExecuteNonQuery() Catch ex As Exception MsgBox(Err.Description) txtbox1.text = Err.Description Finally objCon.Close() recstatus = objCommand.Parameters(2).Value End Try


Reply With Quote