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-16060: Log file is current

1 Answers  


IMP-00002: failed to open string for read

1 Answers  


PCC-02423: Host variable has an invalid type for this option value

1 Answers  


ORA-02705: osnpol: polling of communication channel failed

1 Answers  


ORA-14194: only one subpartition may be rebuilt

1 Answers  






ORA-23537: function or procedure string is not allowed to be invoked from this site.

1 Answers  


ORA-23533: object "string"."string" can not be cached

1 Answers  


RMAN-06716: skipping datafile number; already restored to file string

1 Answers  


ORA-31193: This versioning feature isn't supported for resource string

1 Answers  


ORA-06927: CMX: T_DATAIN received before all data written

1 Answers  


PCB-00101: Could not find or open system configuration file

1 Answers  


ORA-25292: Cannot add buffer on the specified queue

1 Answers  


Categories