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

ORA-19003: Missing XML root element name

1 Answers  


ORA-01952: system privileges not granted to 'string'

1 Answers  


ORA-09759: osnsbt: bad message received.

1 Answers  


ORA-29817: non-supported option with disassociate statement

1 Answers  


TNS-01046: Saved string configuration parameters.

1 Answers  






NCR-01018: NCRS: Encryption failure.

1 Answers  


ORA-02152: Invalid ALTER TABLESPACE ... RENAME option

1 Answers  


ORA-01174: DB_FILES is string buts needs to be string to be compatible

1 Answers  


ORA-06114: NETTCP: SID lookup failure

1 Answers  


QSM-02034: no joins are present in the HAVING clause

1 Answers  


ORA-08323: scnmin: close of bias lock failed

1 Answers  


ORA-23454: flavor string not defined for object group "string"."string"

1 Answers  


Categories