Results 1 to 2 of 2

Thread: strored procedure

  1. #1

    Thread Starter
    Frenzied Member EyeTalion's Avatar
    Join Date
    Jul 2000
    Location
    New York
    Posts
    1,075

    strored procedure

    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
    It's tough being an unhandled exception...

    ___________
    VB.NET 2008
    VB.NET 2010
    ORACLE 11g
    CRYSTAL 11

  2. #2
    Your Ad Here! Edneeis's Avatar
    Join Date
    Feb 2000
    Location
    Moreno Valley, CA (SoCal)
    Posts
    7,339
    It seems like it can't find that stored procedure, are you sure you are connecting to the right database or there isn't a problem with the connection?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width