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

KUP-04011: file system is full

1 Answers  


RMAN-08026: channel string: copied archive log

1 Answers  


RMAN-06092: error while looking up backup piece

1 Answers  


ORA-01883: overlap was disabled during a region transition

1 Answers  


QSM-01082: Joining materialized view, string, with table, string, not possible

1 Answers  


SQL*Loader-00258: Maximum number of SORTED INDEXES (number) exceeded on table string

1 Answers  


ORA-12688: Login failed: the SecurID server rejected the new pincode

1 Answers  


O2I-00101: Invalid value for the USERID parameter

1 Answers  


ORA-13838: invalid ADDRESS value

1 Answers  


ORA-28652: overflow segment attributes cannot be specified

1 Answers  


PLS-00370: OTHERS handler must be last among the exception handlers of a block

1 Answers  


ORA-01934: circular role grant detected

1 Answers  


Categories