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


PLS-00513: PL/SQL function called from SQL must return value
of legal SQL type



PLS-00513: PL/SQL function called from SQL must return value of legal SQL type..

Answer / guest

Cause: In a SQL statement, do not call a PL/SQL function
having a return type that can not be handled by SQL. For
example, type BOOLIAN, records and indexed-tables are not
supported by SQL and functions returneing such values can
not be called from SQL.

Action: none

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

EXP-00037: Export views not compatible with database version

1 Answers  


ORA-15133: instance recovery required for diskgroup string

1 Answers  


ORA-14617: cannot add/drop values to DEFAULT subpartition

1 Answers  


ORA-28118: policy group already exists

1 Answers  


LPX-00405: unable to allocate memory

1 Answers  






PROT-00601: Failed to initialize ocrcheck

1 Answers  


ORA-01571: redo version string incompatible with ORACLE version string

1 Answers  


PLS-00161: Pragma string expects 3rd argument to be an identifier or a string literal

1 Answers  


ORA-29535: source requires recompilation

1 Answers  


ORA-07250: spcre: semget error, unable to get first semaphore set.

1 Answers  


RMAN-07508: cataloging done

2 Answers   Excellence, TCS,


ORA-14508: specified VALIDATE INTO table not found

1 Answers  






Categories