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

RMAN-10013: error initializing PL/SQL

1 Answers  


PCC-00015: Unrecognized Host Language syntax ignored at line number in file string

1 Answers  


O2I-00118: This user-defined type was not found in the database

1 Answers  


SQL*Loader-00559: error closing file

1 Answers  


ORA-36389: (XSAGPARTDEP01) Can not aggregate from PARTITION number into PARTITION number due to increasing sparsity along DIMENSION %J.

1 Answers  


ORA-39041: Metadata filter has no selectivity.

1 Answers  


ORA-13266: error inserting data into table string

1 Answers  


ORA-30677: session is already connected to a debugger

1 Answers  


TNS-12658: ANO service required but TNS version is incompatible

1 Answers  


PLS-00393: wrong number of columns in SELECT...INTO statement

1 Answers  


ORA-02486: Error in writing trace file string

1 Answers  


ORA-06431: ssaio: Invalid Block number

1 Answers  


Categories