Category Archives: Database

PLS-00716: Attribute/method ‘string’ can occur only once in an ALTER TYPE statement

oracle

PLS-00716: Attribute/method 'string' can occur only once in an ALTER TYPE statement
Cause: User attempted more than one of ADD, DROP, or MODIFY on an attribute in a single ALTER TYPE statement. User attempted more than one of ADD or DROP on a method in a single ALTER TYPE statement.
Action: Do only one ADD, DROP, or MODIFY for an attribute in a single ALTER TYPE statement. Do only one ADD or DROP for a method in a single ALTER TYPE statement.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00715: attribute or method by name ‘string’ does not exist

oracle

PLS-00715: attribute or method by name 'string' does not exist
Cause: An attempt was made to drop a nonexistant method or attribute from the type being altered.
Action: Check the spelling of the attribute or method name. Make sure it is locally defined in the type and not inherited.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00714: supertypes’s AUTHID is DEFINER but supertype and subtype are not in same schema

oracle

PLS-00714: supertypes's AUTHID is DEFINER but supertype and subtype are not in same schema
Cause: The supertype's AUTHID is DEFINER, but the supertype and subtype are defined in different schemas. SQL statements executed in dynamically dispatched methods can potentially pick up different values from database tables in the two schemas.
Action: Create the subtype in the same schema as the supertype.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00713: attempting to instantiate a type that is NOT INSTANTIABLE

oracle

PLS-00713: attempting to instantiate a type that is NOT INSTANTIABLE
Cause: An attempt was made to instantiate a type that is defined as NOT INSTANTIABLE.
Action: Avoid instantiating variables of this NOT INSTANTIABLE type; derive an INSTANTIABLE subtype from it and instantiate variables of the subtype.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00712: illegal option for subprogram string

oracle

PLS-00712: illegal option for subprogram string
Cause: Only top level subprograms or subprogram declarations in PACKAGE or TYPE specifications are allowed to have the options DETERMINISTIC or PARALLEL_ENABLE. For example, this error would be raised if the options are used in PACKAGE or TYPE body.
Action: Remove the option.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00711: PRAGMA AUTONOMOUS_TRANS*Action cannot be declared twice

oracle

PLS-00711: PRAGMA AUTONOMOUS_TRANS*Action cannot be declared twice
Cause: The PRAGMA was declared twice in the same block.
Action: Remove the duplicate declaration of the PRAGMA.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00710: PRAGMA AUTONOMOUS_TRANS*Action cannot be declared here

oracle

PLS-00710: PRAGMA AUTONOMOUS_TRANS*Action cannot be declared here
Cause: The PRAGMA was declared in an inappropriate context. This PRAGMA has to be declared in the declarative section of a procedure, a function, a top level anonymous block.
Action: Remove or relocate the misplaced pragma.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00709: pragma string must be declared in package specification and body

oracle

PLS-00709: pragma string must be declared in package specification and body
Cause: The named pragma was declared in a package specification but not in the corresponding package body or vice-versa, as well as the package body.
Action: Add the pragma to that part of the package declaration that does not have the pragma.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00708: Pragma string must be declared in a package specification

oracle

PLS-00708: Pragma string must be declared in a package specification
Cause: The named pragma was not declared in a package specification, as required. For example, the pragma RESTRICT_REFERENCES must be declared in a package specification.
Action: Remove or relocate the misplaced pragma.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00707: unsupported construct or internal error [string]

oracle

PLS-00707: unsupported construct or internal error [string]
Cause: At run time, this is an internal error. At compile time, it indicates one of the following problems: 

A call was made to a remote subprogram that has a parameter type or default expression not supported at the calling site. 

An incomplete upgrade or downgrade was done to a database that has stored procedures. Perhaps incorrect versions of system packages such as STANDARD.SQL were installed. 

A compiler bug was encountered. In such cases, legal PL/SQL syntax will fail to compile.
Action: Either report the internal error to Oracle Support Services or, depending on the problem, take one of the following actions: 

Revise the logic of the application to use parameter types and default expressions that are supported at both the local and remote sites. 

Complete the upgrade or downgrade properly, making sure to install correct versions of all system packages. 

Report the legal-syntax error to Oracle Support Services. If there are line and column numbers displayed with the error message, they might help you find a workaround. For example, try recoding the offending line to avoid the bug.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/