PLS-00661: RETURN statement in a CONSTRUCTOR cannot include an expression
Cause: An attempt was made to include an expression in the RETURN statement of a CONSTRUCTOR body.
Action: Remove the expression from the RETURN statement.
Category Archives: Database
PLS-00660: SELF parameter of constructor method must be IN OUT
PLS-00660: SELF parameter of constructor method must be IN OUT
Cause: The mode of the SELF parameter of the constructor was not IN OUT.
Action: Change the mode of the SELF parameter to be IN OUT.
PLS-00659: constructor method must return SELF AS RESULT
PLS-00659: constructor method must return SELF AS RESULT
Cause: The return clause of the constructor method did not specify SELF AS RESULT.
Action: Change the return clause to include RETURN SELF AS RESULT.
PLS-00658: constructor method name must match type name
PLS-00658: constructor method name must match type name
Cause: The name of the object type constructor does not match the type name.
Action: Change the name of the constructor method to match the type name.
PLS-00657: Implementation restriction: bulk SQL with associative arrays with VARCHAR2 key is not supported
PLS-00657: Implementation restriction: bulk SQL with associative arrays with VARCHAR2 key is not supported
Cause: Variable or expression of associative array type was used as bulk SQL bind or define.
Action: Use collection types supported by bulk SQL.
PLS-00656: field ‘string’ not available in input argument
PLS-00656: field 'string' not available in input argument
Cause: An EXTRACT operation specified a field that was not present. For example, an attempt was made to extract the YEAR field from a TIME variable.
Action: Specify a legal field in the call to EXTRACT.
PLS-00655: only functions can be declared as PIPELINED
PLS-00655: only functions can be declared as PIPELINED
Cause: An attempt was made to declare a procedure to be a pipelined function.
Action: Declare a function instead of a procedure to be a pipelined function.
PLS-00654: PARTITION/ORDER/CLUSTER BY is only allowed for with PARALLEL_ENABLE
PLS-00654: PARTITION/ORDER/CLUSTER BY is only allowed for with PARALLEL_ENABLE
Cause: An attempt was made to use either PARTITION BY, ORDER BY, or CLUSTER BY clauses without parallel enable clause in table function.
Action: Specify parallel enable also when using PARTITION BY, CLUSTER BY, or ORDER BY clauses.
PLS-00653: aggregate/table functions are not allowed in PL/SQL scope
PLS-00653: aggregate/table functions are not allowed in PL/SQL scope
Cause: An attempt was made to use a table/aggregate function in PL/SQL scope.
Action: Do not use table/aggregate functions in PL/SQL scope.
PLS-00652: aggregate functions should have exactly one argument
PLS-00652: aggregate functions should have exactly one argument
Cause: An attempt was made to create an aggregate function with either 0 or more than one arguments.
Action: Do not create aggregate functions with 0 or more than one arguments.