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-06404: NETCMN: invalid login (connect) string

1 Answers  


ORA-13611: The command string is not a valid advisor command.

1 Answers  


ORA-32613: not a MODEL cell

1 Answers  


ORA-12444: policy already applied to table

1 Answers  


O2I-00123: Unable to close the INITFILE file

1 Answers  






ORA-34021: (MSCGADD04) You must specify a partition when maintaining PARTITION TEMPLATE workspace object.

1 Answers  


ORA-36690: (NTEXTCNV01) Error during conversion from NTEXT to TEXT.

1 Answers  


DRG-11852: Can't Locate Remote Host

1 Answers  


ORA-13850: Tracing for client identifier string is not enabled

1 Answers  


ORA-25471: attribute name not specified for variable: string

1 Answers  


ORA-13282: failure on initialization of coordinate transformation

1 Answers  


ORA-38709: Recovery Area is not enabled.

3 Answers  


Categories