PLS-00633: RETURN statement in a pipelined function cannot
contain an expression



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

Post New Answer

More Oracle Errors Interview Questions

PCC-00133: Command line option MODE=ANSI required with option NLS_LOCAL=YES

1 Answers  


ORA-36986: (XSRELGID05) Relation workspace object must be dimensioned by workspace object.

1 Answers  


NNL-00555: Displays meta data statistics

1 Answers  


QSM-01115: rollup took place on a column with a window function

1 Answers  


LSX-00162: string "~S" is an invalid default for the complex type

1 Answers  


ORA-02804: Allocation of memory failed for log file name

1 Answers  


ORA-24157: duplicate variable name string

1 Answers  


SQL*Loader-00640: Variable length field was truncated.

1 Answers  


TNS-12236: TNS:protocol support not loaded

1 Answers  


SQL*Loader-00411: Only a direct path load may be continued

1 Answers  


NNL-00407: Alias translations:

1 Answers  


ORA-12440: insufficient authorization for the SYSDBA package

1 Answers  


Categories