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

TNS-01025: Security string

1 Answers  


ORA-02838: Unable to arm signal handler for the alarm signal

1 Answers  


ORA-16071: dependency archived log file not found string

1 Answers  


ORA-32609: missing REFERENCE keyword in MODEL clause

1 Answers  


DRG-11802: Switching Protocols

1 Answers  






NNL-00244: Processing of modification requests is now disabled

1 Answers  


ORA-19777: ASM file string cannot be proxy backed up.

1 Answers  


ORA-16739: log transport service for standby "string" unexpectedly online

1 Answers  


IMP-00045: using VOLSIZE value from export file of string

1 Answers  


ORA-18015: invalid source outline signature

1 Answers  


ORA-14026: PARTITION and CLUSTER clauses are mutually exclusive

1 Answers  


ORA-21503: program terminated by fatal error

1 Answers  


Categories