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-14118: CHECK constraint mismatch in ALTER TABLE EXCHANGE PARTITION

1 Answers  


ORA-19675: file string was modified during proxy copy

1 Answers  


NID-00442: Database has been shutdown, open database with RESETLOGS option.

1 Answers  


ORA-02065: illegal option for ALTER SYSTEM

1 Answers  


ORA-31619: invalid dump file "string"

1 Answers  






NNL-00244: Processing of modification requests is now disabled

1 Answers  


DRG-11868: Too Many Redirections

1 Answers  


ORA-26062: Can not continue from previous errors.

1 Answers  


ORA-01355: logminer tablespace change in progress

1 Answers  


ORA-31492: could not set session parameters for LogMiner session

1 Answers  


ORA-21703: cannot flush an object that is not modified

1 Answers  


ORA-24075: cannot specify agent with NULL address and non-NULL protocol

1 Answers  


Categories