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-20000: %s

1 Answers  


ORA-13903: Invalid combination of string threshold value and operator.

1 Answers  


LFI-00141: Unable to abort file in operation string.

1 Answers  


ORA-31073: Resource not retrieved using path name

1 Answers  


ORA-06750: TLI Driver: sync failed

1 Answers  






ORA-10571: Test recovery canceled

1 Answers  


ORA-07606: szprv: $CHKPRO failure

1 Answers  


ORA-07624: smsdes: $DGBLSC failure

1 Answers  


SQL*Loader-00509: System error: string

1 Answers  


ORA-06130: NETTCP: host access denied

1 Answers  


DRG-12440: document table read failed

1 Answers  


IMG-00811: fail queue initialization failed

1 Answers  


Categories