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-13155: invalid number of dimensions specified

1 Answers  


ORA-25185: index column other than last can not be specified for INCLUDE clause

1 Answers  


RMAN-20503: DELETE cannot delete expired objects - run CROSSCHECK or DELETE EXPIRED

1 Answers  


RMAN-06021: FROM DATAFILECCOPY/BACKUPSET may not be specified with archive logs

1 Answers  


DRG-50852: failed to turn SQL trace on

1 Answers  






TNS-12686: Invalid command specified for a service

1 Answers  


ORA-14075: partition maintenance operations may only be performed on partitioned indices

1 Answers  


ORA-14108: illegal partition-extended table name syntax

1 Answers  


RMAN-06517: KEEP option is not supported for archive log backups

1 Answers  


ORA-03290: Invalid truncate command - missing CLUSTER or TABLE keyword

1 Answers  


SQL*Loader-00520: lfimknam failed for file (string)

1 Answers  


SQL*Loader-00527: OCI return status: no data

1 Answers  


Categories