Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-00014: INTCTL: error while opening terminal input channel

1 Answers  


ORA-12468: max write level does not equal max read level

1 Answers  


ORA-22606: pickler image handle [string] is not well-formed

1 Answers  


ORA-01222: MAXINSTANCES of string requires MAXLOGFILES be at least string, not string

1 Answers  


LPX-00406: object of incorrect type passed to the function

1 Answers  






IMG-00730: unable to process empty image

1 Answers  


UDI-00053: unrecognized client command 'string'

1 Answers  


ORA-02765: Invalid maximum number of servers

1 Answers  


TNS-12671: Shared server: adapter failed to save context

1 Answers  


ORA-37131: (XSCCOMP06) Cannot aggregate VARIABLE workspace object using AGGMAP workspace object because the OPERATOR string is not supported for bases of a COMPRESSED COMPOSITE.

1 Answers  


ORA-26563: renaming this table is not allowed

1 Answers  


DRG-13012: language column must be a char, varchar, or varchar2 type

1 Answers  






Categories