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

PCC-00003: Invalid SQL Identifier at column number in line number of file string

1 Answers  


NID-00333: Cannot read the header of the following datafiles:

1 Answers  


SQL*Loader-00508: record formating error in data file string

1 Answers  


ORA-31217: DBMS_LDAP: PL/SQL - Invalid LDAP newparent.

1 Answers  


KUP-00600: internal error, arguments [string] [string] [string] [string] [string]

1 Answers  


ORA-13012: an invalid window type was specified

1 Answers  


ORA-09800: Process sensitivity label retrieval failed.

1 Answers  


DRG-10822: duplicate query name

1 Answers  


SQL*Loader-00109: Invalid number of logical records to skip

1 Answers  


DRG-11862: This Is Probaly A HTTP Server 0.9 Or Less

1 Answers  


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

1 Answers  


PLS-01900: : character to number conversion error

1 Answers  


Categories