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

ORA-25444: invalid ROWID: string for table alias: string

1 Answers  


ORA-06021: NETASY: connect failed

1 Answers  


ORA-12537: TNS:connection closed

2 Answers   State Bank Of India SBI,


when i open the data base the data base gives error as initalishing or terminating how i log into data base

1 Answers  


ORA-24753: local transactions cannot be detached

1 Answers  






ORA-29371: pending area is not active

1 Answers  


ORA-04091: table string.string is mutating, trigger/function may not see it

1 Answers  


ORA-01156: recovery in progress may need access to files

2 Answers  


ORA-06514: PL/SQL: The remote call cannot be handled by the server

1 Answers  


PLS-00406: length of SELECT list in subquery must match number of assignment targets

1 Answers  


ORA-01117: adding file 'string' with illegal block size: string; limit is string

1 Answers  


ORA-03293: Cluster to be truncated is a HASH CLUSTER

1 Answers  


Categories