PLS-00457: expressions have to be of SQL types



PLS-00457: expressions have to be of SQL types..

Answer / guest

Cause: an expression of wrong type is in USING or dynamic
RETURNING clause. In USING or dynamic RETURNING clause, an
expression cannot be of non-SQL types such as BOOLEAN, INDEX
TABLE, and record.

Action: change the expression type to a SQL type.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-09877: sstascre: shmget error, unable to get a shared memory segment.

1 Answers  


ORA-07304: ksmcsg: illegal redo buffer size.

1 Answers  


ORA-00071: process number must be between 1 and string

1 Answers  


PCB-00311: Datatype equivalencing is an Oracle extension

1 Answers  


ORA-19017: Attributes can only be simple scalars

1 Answers  






NNL-00970: System query index number: number

1 Answers  


ORA-09765: osnmop: fork failed

1 Answers  


NCR-02008: NCRF: Error within stream processing in format interpreter

1 Answers  


ORA-02233: invalid CLOSE mode

1 Answers  


ORA-37060: (XSMCSESS08) number is not a valid custom member in dimension workspace object.

1 Answers  


QSM-02059: join may produce duplicate rows in mv

1 Answers  


RMAN-20206: log sequence not found in the repository

1 Answers  


Categories