solve ORA-6550

20 pts.
Oracle 10g
Oracle 10g administration
Oracle error messages
Oracle stored procedures
how to solve ORA-6550 PLS-00201 when trying to run a stored procedure in Oracle10g

Answer Wiki

Thanks. We'll let you know when a new response is added.

ORA-6550 is ‘compilation error’ and PLS-00201 means that you tried to use an identifier that has not been declared (if it refers to a database object, it could mean that you don’t have the appropriate privileges).

The error message should include a line and column number, which indicates where the error occurs exactly.

If you need further help, please post your code and the complete error message.


Discuss This Question: 6  Replies

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Amitjoshi01
    Hello, I am getting the following error message: ===== SQL Error (if any) SQLCODE = -6550, SQLErrorMsg = ORA-06550: line 1, column 7: PLS-00201: identifier 'UPDATE_ONLINE_PROG ===== The object UPDATE_ONLINE_PROG is in compiled state but still i am getting this error. Could you please tell me the cause of this error and solution for the same? Please also note that my application program is calling this procedure at runtime. Any kind of help is appreciated.
    10 pointsBadges:
  • carlosdl
    Can you post your code ? Are you able to run the UPDATE_ONLINE_PROG procedure directly (from SQL*Plus for example) using the same user account the application uses ?
    85,885 pointsBadges:
  • freudania
    voici mon code
    create or replace
    , nbre out number
      select count(*) into nbre from COORDONATEUR where NOMCOORD=pNOM and PRENOMCOORD=pPRENOM;

    voici comment je l'appel en VB.Net

    Public Function Existe(ByVal LeNom As String, ByVal LePrenom As String) As Boolean
            Dim bool As Boolean = False
            '== controle de doublon
                LaCmdSql.CommandText = "PS_EXISTE_COORD"
                LaCmdSql.CommandType = CommandType.StoredProcedure
                With LaCmdSql
                    .Parameters.Add(New OracleClient.OracleParameter("pNOM", OracleClient.OracleType.NVarChar)).Value = Me.getNom
                    .Parameters.Add(New OracleClient.OracleParameter("pPRENOM", OracleClient.OracleType.NVarChar)).Value = Me.getPrenom
                    .Parameters.Add(New OracleClient.OracleParameter("NBRE", OracleClient.OracleType.Int32)).Direction = ParameterDirection.Output
                End With
                LaCmdSql.Connection = Cnx
                If CInt(LaCmdSql.Parameters("NBRE").Value) > 0 Then
                    bool = True
                End If
            Catch ex As Exception
            End Try
            Existe = bool
        End Function
    20 pointsBadges:
  • freudania
    et voici le message que je reçoit:message = "ORA-06550: Ligne 1, colonne 7 : PLS-00306: numéro ou types d'arguments erronés dans appel à 'PS_EXISTE_COORD' ORA-06550: Ligne 1, colonne 7 : PL/SQL: Statement ignored "
    20 pointsBadges:
  • carlosdl
    You need to put semicolons after each line (not commas) In your case: create or replace PROCEDURE PS_EXISTE_COORD ( pNOM IN VARCHAR2; pPRENOM IN VARCHAR2; nbre out number; ) AS  
    85,885 pointsBadges:
  • purshotam

    Hi ,

    I am getting the error mentioned below . Please help me out.

    Error report:
    ORA-06550: line 1, column 7:
    PLS-00306: wrong number or types of arguments in call to 'PROCEDURE_Name'
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored
    06550. 00000 -  "line %s, column %s:\n%s"
    *Cause:    Usually a PL/SQL compilation error.

    10 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: