PLS-00513: PL/SQL function called from SQL must return value
of legal SQL type
- 1 Answers
- 4447 Views
- I also Faced
- E-Mail Answers
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 |
SQL-02124: NULL value returned by EXEC TOOLS statement
PCC-02106: Userid only used when SQLCHECK = FULL, userid ignored.
PCC-00090: Precision/scale specification must be given for DECIMAL datatype
PLS-00730: collection element type does not allow modifications
ORA-36718: (XSALLOC00) You do not have the necessary permissions to use AGGMAP workspace object.
PLS-00114: identifier 'string' too long
ORA-29803: missing ANCILLARY keyword
RMAN-06587: one or more datafilecopies were not found
ORA-02185: a token other than WORK follows COMMIT
ORA-27043: unable to seek to beginning of file
ORA-24335: cannot support more than 1000 columns
ORA-14195: ALLOCATE STORAGE may not be specified for RANGE or LIST partitioned object
Oracle Errors 
