PLS-00706: Exception string cannot be used as prefix of a selected component
Cause: An exception name was mistakenly used to qualify a reference to a component. For example, when dot notation was used to specify fields within a record, an exception name might have been coded instead of the record name.
Action: Rewrite the component reference using a valid prefix (for example, the name of a package, record, or schema).
PLS-00705: exception 'string' used in expression requiring return type
Cause: An exception was referred to in an expression. Exceptions have names but not values and therefore cannot contribute values to an expression. For example, the following RETURN statement is illegal: FUNCTION credit_limit (cust_no INTEGER) RETURN NUMBER IS limit NUMBER; over_limit EXCEPTION; ... BEGIN ... RETURN over_limit; -- illegal END;
Action: Check the spelling of the identifiers in the expression, then rewrite the expression so that it does not refer to an exception.
PLS-00704: 'string' must be declared as an exception
Cause: The EXCEPTION_NAME parameter passed to an EXCEPTION_INIT pragma is misspelled or does not refer to a legally declared exception. Or, the pragma is misplaced; it must appear in the same declarative section, somewhere after the exception declaration.
Action: Check the spelling of the EXCEPTION_NAME parameter. Then, check the exception declaration, making sure the exception name and the keyword EXCEPTION are spelled correctly. Also make sure the pragma appears in the same declarative section somewhere after the exception declaration.
PLS-00703: multiple instances of named argument in list
Cause: Two or more actual parameters in a subprogram call refer to the same formal parameter.
Action: Remove the duplicate actual parameter.
PLS-00702: second argument to PRAGMA EXCEPTION_INIT must be a numeric literal
Cause: The second argument passed to an EXCEPTION_INIT pragma was something other than a numeric literal (a variable, for example). The second argument must be a numeric literal in the range -9999 .. -1 (excluding -100) for Oracle errors or in the range -20000 .. -20999 for user-defined errors.
Action: Replace the second argument with a valid error number.
PLS-00701: illegal ORACLE error number string for PRAGMA EXCEPTION_INIT
Cause: The error number passed to an EXCEPTION_INIT pragma was out of range. The error number must be in the range -9999 .. -1 (excluding -100) for Oracle errors or in the range -20000 .. -20999 for user-defined errors.
Action: Use a valid error number.
PLS-00700: PRAGMA EXCEPTION_INIT of string must follow declaration of its exception in the same declarative part
Cause: An EXCEPTION_INIT pragma was not declared in the same block as its exception. They must be declared in the proper order in the same block, with the pragma declaration following the exception declaration.
Action: Place the EXCEPTION_INIT pragma directly after the exception declaration referenced by the pragma.
PLS-00664: Both ORDER BY and CLUSTER BY can not be specified for the same table function
Cause: An attempt was made to specify both ORDER BY and CLUSTER BY for the same table function.
Action: Specify either ORDER BY or CLUSTER BY for a table function, but not both.
PLS-00663: the NEW keyword is not allowed in this context
Cause: The NEW keyword is not followed by a call to a constructor method.
Action: Remove the NEW keyword, or make sure the expression following it is a constructor call.
PLS-00662: Non-external object types containing external mapped attributes are not allowed
Cause: An attempt was made to create a non-external object, whose attributes are mapped externally.
Action: Create the object as an external object.