PLS-00500 TO PLS-00599

oracle

PLS-00500: invalid operator binding

PLS-00503: RETURN value statement required for this return from function

PLS-00504: type string_BASE may not be used outside of package STANDARD

PLS-00505: User Defined Types may only be defined as PLSQL Tables or Records

PLS-00506: User Defined Constrained Subtypes are disallowed

PLS-00507: a PLSQL Table may not contain a table or a record with composite fields

PLS-00508: The expression in a RETURN statement cannot be a type

PLS-00509: Implementation Restriction : Pass a returned record to a temporary identifier before selecting a field

PLS-00510: Float cannot have scale

PLS-00511: a record may not contain a PL/SQL table of records

PLS-00512: Implementation Restriction: ‘string’: Cannot directly access remote package variable or cursor

PLS-00513: PL/SQL function called from SQL must return value of legal SQL type

PLS-00514: INSERT statement with REF INTO clause requires a typed table

PLS-00515: The type of the REF INTO variable ‘string’ must be REF to the table’s type

PLS-00516: Type mismatch between object table and value ‘string’ in INSERT statement

PLS-00517: Type mismatch between a select list element ‘string’ and corresponding table column in INSERT statement with a subquery

PLS-00518: This INSERT statement requires VALUES clause containing a parenthesised list of values

PLS-00519: This INSERT statement requires a VALUES clause containing an object type expression, not a list of values

PLS-00520: MAP methods must be declared without any parameters other than (optional) SELF

PLS-00521: ORDER methods must be declared with 1 (one) parameter in addition to (optional) SELF

PLS-00522: MAP methods must return a scalar type

PLS-00523: ORDER methods must return an INTEGER

PLS-00524: The parameter type in an ORDER method must be the containing object type

PLS-00525: Within SQL statements, only equality comparisons of objects are allowed without a map or order function

PLS-00526: A MAP or ORDER function is required for comparing objects in PL/SQL

PLS-00527: MAP or ORDER functions require a PRAGMA RESTRICT_REFERENCES specifying :WNDS,WNPS,RNPS,RNDS

PLS-00528: The parameters to an ORDER function must have IN mode

PLS-00529: Bad column name string in INSERT statement (must be an identifier)

PLS-00530: Illegal type used for object type attribute: ‘string’

PLS-00531: Unsupported type in a VARRAY or TABLE type: ‘string’

PLS-00532: Target of REF must be a complete or incomplete object type

PLS-00533: Tables of non_queryable types are not supported

PLS-00534: A Table type may not contain a nested table type or VARRAY

PLS-00535: A VARRAY type may not contain a NESTED TABLE, VARRAY or LOB

PLS-00536: Navigation through REF variables is not supported in PL/SQL

PLS-00537: A VARRAY must have a positive limit

PLS-00538: subprogram or cursor ‘string’ is declared in an object type specification and must be defined in the object type body

PLS-00539: subprogram ‘string’ is declared in an object type body and must be defined in the object type specification

PLS-00540: object not supported in this context

PLS-00541: size or length specified is too large

PLS-00542: CLOB and NCLOB cannot use varying-width character sets in the server

PLS-00543: a PLSQL Table may not contain a nested table type or VARRAY

PLS-00546: SELF may not be declared as a REF parameter

PLS-00548: invalid use of operator

PLS-00550: character set specification is not allowed for this type

PLS-00551: character set ANY_CS is only allowed on a subprogram parameter

PLS-00552: flexible character set is not allowed on component element

PLS-00553: character set name is not recognized

PLS-00554: character set has already been determined

PLS-00555: default expressions are not allowed for SQL operators

PLS-00560: character set mismatch

PLS-00561: character set mismatch on value for parameter ‘string’

PLS-00562: a function must return a type

PLS-00563: illegal use of CAST expression

PLS-00564: lob arguments are not permitted in calls to remote server

PLS-00565: string must be completed as a potential REF target (object type)

PLS-00566: type name “string” cannot be constrained

PLS-00567: cannot pass NULL to a NOT NULL constrained formal parameter

PLS-00568: cannot access rows from a non-nested table item

PLS-00569: numeric overflow or underflow

PLS-00570: different number of columns in the multiset and cast expressions

PLS-00571: method access through data base link not yet supported on client side

PLS-00572: improper constraint form used

PLS-00573: cannot constrain scale, precision, or range of an anchored type declaration

PLS-00580: supertype must be an object type

PLS-00581: inheritance is not supported for opaque types

PLS-00582: attribute declarations are not allowed in opaque types

PLS-00583: size must be specified if opaque type is fixed-length

PLS-00584: size of an opaque type must be between 1 and 4000 bytes

PLS-00585: declared support library for opaque type is not a library

PLS-00586: a static method cannot declare a parameter named SELF

PLS-00587: a static method cannot be invoked on an instance value

PLS-00588: unqualified instance attribute references allowed only in member methods

PLS-00589: no attributes found in object type “string”

PLS-00590: attempting to create a subtype UNDER a FINAL type

PLS-00591: this feature is not supported in client-side programs

PLS-00592: the type of a object table must be an object type

PLS-00593: default value of parameter ‘string’ in body must match that of spec

PLS-00594: the SELF parameter can be declared only as IN or as IN OUT

PLS-00595: the TABLE operator is not allowed in this context

PLS-00597: expression string in the INTO list is of wrong type

PLS-00598: comparison of object with NULL using string is not allowed

PLS-00599: SAMPLE percentage must be in the range [0.000001,100)

Back to ALL PLS-CODE TRACKS

Back to ALL PLS-CODE LIST

https://support.oracle.com/

http://www.oracle.com/

Translate »