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

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

Oracle Error Message

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

Reason for the Error

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.

Solution

Either report the internal error to your Customer Support representative 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 your Customer Support representative. 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.

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

Oracle Error Message CLSGN-32767: Internal error. Reason for the Error An unexpected error occurred. Solution Examine the message(s) that accompany...
Oracle Error Message CLSGN-00211: OCR batch operation failed. string Reason for the Error Setting a set of Oracle Cluster Registry...
Oracle Error Message CLSGN-00210: failed to get value for OCR key “string”. string Reason for the Error It was not...