Category Archives: Database

PLS-00751: cannot find PACKAGE SYS_STUB_FOR_PURITY_ANALYSIS

oracle

PLS-00751: cannot find PACKAGE SYS_STUB_FOR_PURITY_ANALYSIS
Cause: A top level subprogram (function or procedure) cannot be created if the system package SYS_STUB_FOR_PURITY_ANALYSIS is missing in the Oracle database.
Action: Make sure the package is in the database, and retry the creation.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00725: type ‘string’ must be a supertype or subtype of the TREAT expression

oracle

PLS-00725: type 'string' must be a supertype or subtype of the TREAT expression
Cause: In TREAT(expr AS type), type must be a supertype or subtype of expr.
Action:

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00724: package body cannot be compiled to bytecode if its spec was compiled native

oracle

PLS-00724: package body cannot be compiled to bytecode if its spec was compiled native
Cause: The package body is being compiled to interpreted bytecode whereas the corresponding package specification was compiled to native code.
Action: Compile the package body to the same target (native code or interpreted bytecode) as its spec.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00723: package body cannot be compiled native if its spec was compiled non-native

oracle

PLS-00723: package body cannot be compiled native if its spec was compiled non-native
Cause: The package body is being compiled to native code whereas the corresponding package specification was compiled to interpreted bytecode.
Action: Compile the package body to the same target (native code or interpreted bytecode) as its spec.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00722: supertypes’s AUTHID is different than subtype’s AUTHID

oracle

PLS-00722: supertypes's AUTHID is different than subtype's AUTHID
Cause: The subtype's AUTHID must be the same as the supertype's AUTHID.
Action: Create the subtype with the AUTHID of its supertype or do not specify an AUTHID for the subtype.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00721: ‘string’ formed a non-REF mutually-dependent cycle with ‘string’

oracle

PLS-00721: 'string' formed a non-REF mutually-dependent cycle with 'string'
Cause: This compilation was aborted because the library unit that was compiled would have formed a non-REF mutually-dependent cycle with some other library units. This happens when an attempt is made to compile types that have attributes of other types that may participate in a cycle with this type. 

create type t1; 

create type t2 (a t1); 

create type t1 (a t2);
Action: Break the cycle (possibly by adding a REF or by using another type).

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00720: type ‘string’ has evolved

oracle

PLS-00720: type 'string' has evolved
Cause: The type has evolved. The version of the type used by the compiled code is not the same as the latest version of the type.
Action: Recompile the code to use the latest version of the type.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00719: only widening of attribute ‘string’ constraints is allowed

oracle

PLS-00719: only widening of attribute 'string' constraints is allowed
Cause: Modification to the attribute did not widen its constraints or attempted to change the type of the attribute. For NUMBER type attributes, scale and precision can be changed to allow increase in number of digits after and before the decimal point. For VARCHAR2 and RAW type attributes the size can be increased. Other type attributes are not allowed to be modified. Change of type of attribute is also not allowed.
Action: Change the constraint specification so as to widen the existing constraints.To narrow the constraints or to change the type of the attribute, you must drop the attribute and add it with new constraints or new type. In that case you must also take appropriate steps to preserve your existing data based on the type (if you want to preserve it).Typically this will involve backing up the data and restoring it after the ALTER TYPE.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00718: type of attribute ‘string’ does not allow modifications to the attribute

oracle

PLS-00718: type of attribute 'string' does not allow modifications to the attribute
Cause: The type of the attribute to modify is not one of VARCHAR2, NUMBER, or RAW.
Action: Only VARCHAR2, NUMBER and RAW type attributes are allowed to be modified.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00717: method ‘string’ does not have matching signature among existing methods

oracle

PLS-00717: method 'string' does not have matching signature among existing methods
Cause: The method to be dropped matches the name of some existing method but does not match it in signature.
Action: Make sure that a matching method signature is provided for dropping a method.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/