PLS-00633: RETURN statement in a pipelined function cannot
contain an expression
Answer / guest
Cause: A RETURN statement in a pipelined function contains
an expression, which is not allowed. Pipelined functions
must send back values to the caller by using the PIPE statement.
Action: Remove the expression from the RETURN statement and
use a PIPE statement to return values. Else, convert the
function into a non-pipelined function.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
PCC-00133: Command line option MODE=ANSI required with option NLS_LOCAL=YES
ORA-36986: (XSRELGID05) Relation workspace object must be dimensioned by workspace object.
NNL-00555: Displays meta data statistics
QSM-01115: rollup took place on a column with a window function
LSX-00162: string "~S" is an invalid default for the complex type
ORA-02804: Allocation of memory failed for log file name
ORA-24157: duplicate variable name string
SQL*Loader-00640: Variable length field was truncated.
TNS-12236: TNS:protocol support not loaded
SQL*Loader-00411: Only a direct path load may be continued
NNL-00407: Alias translations:
ORA-12440: insufficient authorization for the SYSDBA package