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-02455: The number of cluster key column must be 1

1 Answers  


ORA-19601: output file is string string (string)

1 Answers  


ORA-01204: file number is string rather than string - wrong file

1 Answers  


QSM-01070: equivalence class manager was not found

1 Answers  


ORA-13390: error in spatial analysis and mining function: [string]

1 Answers  






NNO-00159: warning: ignoring duplicate hint domain number name "string"

1 Answers  


ORA-19557: device error, device type: string, device name: string

1 Answers  


RMAN-20220: controlfile copy not found in the recovery catalog

1 Answers  


ORA-33016: (XSAGDNGL07) In AGGMAP workspace object, workspace object is not a valid operator or variable name.

1 Answers  


RMAN-08531: channel string: proxy copy string is string in media management catalog

1 Answers  


SQL*Loader-00800: %s specified and ignored

1 Answers  


ORA-31104: Cannot find lock with token "string" on "string" for unlock

1 Answers  


Categories