PLS-00705: exception 'string' used in expression requiring
return type



PLS-00705: exception 'string' used in expression requiring return type..

Answer / guest

Cause: An exception was referred to in an expression.
Exceptions have names but not values and therefore cannot
contribute values to an expression. For example, the
following RETURN statement is illegal: FUNCTION credit_limit
(cust_no INTEGER) RETURN NUMBER IS limit NUMBER; over_limit
EXCEPTION; ... BEGIN ... RETURN over_limit; -- illegal END;

Action: Check the spelling of the identifiers in the
expression, then rewrite the expression so that it does not
refer to an exception.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-08231: smscre: unable to attach to SGA

1 Answers  


ORA-02020: too many database links in use

2 Answers  


LSX-00294: field "~S" produced multiple hits

1 Answers  


LRM-00122: value 'string' for 'string' must be between 'number' and 'number'

1 Answers  


DRG-10599: column is not indexed

1 Answers  






RMAN-04005: error from target database: string

1 Answers  


ORA-23324: error string, while creating deferror entry at "string" with error string

1 Answers  


PCB-00626: Incompatible LOB types

1 Answers  


ORA-19704: file name exceeds maximum length of string

1 Answers  


ORA-12830: Must COMMIT or ROLLBACK after executing parallel INSERT/UPDATE/DELETE

1 Answers  


LPX-00104: element "~S" is not declared in the DTD

1 Answers  


NNO-00115: line string: single-value data type "string", other instances ignored

1 Answers  


Categories