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:
  1. Dim objCommand As New OleDbCommand()
  2.         Try
  3.             objCommand.Connection = objCon
  4.             objCommand.CommandText = "SP_PCMS_APPROVE_CARD"
  5.             objCommand.CommandType = CommandType.StoredProcedure
  6.             objCommand.Parameters.Add(New OleDbParameter("t_card", OleDbType.Numeric)).Value = cardNo
  7.             objCommand.Parameters.Add(New OleDbParameter("t_end_date", OleDbType.Date)).Value = tranPeriodEnd
  8.             objCommand.Parameters.Add(New OleDbParameter("t_error", OleDbType.VarChar, 1)).Direction = ParameterDirection.Output
  9.             objCon.Open()
  10.             objCommand.ExecuteNonQuery()
  11.         Catch ex As Exception
  12.             MsgBox(Err.Description)
  13.             txtbox1.text = Err.Description
  14.         Finally
  15.             objCon.Close()
  16.             recstatus = objCommand.Parameters(2).Value
  17.         End Try