Category Archives: Uncategorized

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

oracle

PLS-00536: Navigation through REF variables is not supported in PL/SQL
Cause: The expression of the form REFVAR.FIELD was entered. This is not supported in this version of PL/SQL.
Action: This navigation is only supported for database objects. The REF variable can be used to insert into a database column of the same type, or select from it. However, you will not be able to navigate through it. Remove the navigation.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

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

oracle

PLS-00535: A VARRAY type may not contain a NESTED TABLE, VARRAY or LOB
Cause: An attempt was made to do one of the following: define a VARRAY type containing a nested collection type or LOB or define a VARRAY type of an object type that has a nested attribute which is one of NESTED TABLE, VARRAY or LOB type.
Action: Check the VARRAY definitions to be sure that they do not contain nested collection types, LOBs or nested attributes.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

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

oracle

PLS-00534: A Table type may not contain a nested table type or VARRAY
Cause: An attempt was made to do one of the following: define a table type which contained nested collection types. or define an object table that has (perhaps nested) another table type or VARRAY type.
Action: Check the table definitions to be sure that they do not contain nested tables or VARRAYs.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00533: Tables of non_queryable types are not supported

oracle

PLS-00533: Tables of non_queryable types are not supported
Cause: An attempt was made to create a table of a type which cannot be queried. Tables of such types are not supported.
Action: Create an object type containing the non-queryable type. Then create a table of the object type.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

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

oracle

PLS-00532: Target of REF must be a complete or incomplete object type
Cause: The target of a REF can only be a complete or an incomplete object type.
Action: If a REF is to be used, change the type; otherwise, remove the REF.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

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

oracle

PLS-00531: Unsupported type in a VARRAY or TABLE type: 'string'
Cause: An attempt was made to use an unsupported type in a VARRAY or TABLE type.
Action: Use only supported types in a VARRAY or TABLE type.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

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

oracle

PLS-00530: Illegal type used for object type attribute: 'string'
Cause: An attempt was made to use an invalid type for an object type attribute.
Action: Use only supported types for the object type attribute.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

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

oracle

PLS-00529: Bad column name string in INSERT statement (must be an identifier)
Cause: In an INSERT statement, an attempt was made to use a column name that is not an identifier. In any INSERT statement with explicit column list a column name must be a simple identifier.
Action: Rewrite the INSERT statement, using a simple identifier for the column name.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

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

oracle

PLS-00528: The parameters to an ORDER function must have IN mode
Cause: A parameter was declared to an ORDER function to have OUT or IN OUT mode.
Action: Correct the parameter to use IN mode only.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

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

oracle

PLS-00527: MAP or ORDER functions require a PRAGMA RESTRICT_REFERENCES specifying :WNDS,WNPS,RNPS,RNDS
Cause: Either a PRAGMA RESTRICT_REFERENCES was not specified or it was specified without one of the following: WNDS, WNPS, RNPS, or RNDS.
Action: Add or correct the PRAGMA and retry the operation.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/