PLS-00633: RETURN statement in a pipelined function cannot
contain an expression
- 1 Answers
- 5417 Views
- I also Faced
- E-Mail Answers
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 |
SQL*Loader-00405: Need termination delim with optional enclosure delim: column string table string
ORA-16776: Health check of the log transport service failed.
DRG-11845: No Partial Update
QSM-01060: illegal subquery in the HAVING clause
NCR-02005: NCRF: Invalid session mode
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORA-38438: getVarchar not possible due to "string" datatype in the attribute set
SQL*Loader-00804: SEQUENCES with intervals are not supported by External Table Load.
ORA-29935: missing FROM keyword
SQL*Loader-00642: Relative start position > absolute field end position.
LFI-00105: Unable to add path.
RMAN-06497: WARNING: controlfile is not current, controlfile autobackup skipped
Oracle Errors 
