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

RMAN-06607: RMAN configuration parameters are:

1 Answers  


RMAN-06026: some targets not found - aborting restore

1 Answers  


TNS-12631: Username retrieval failed

1 Answers  


ORA-31511: name exceeds maximum length of 30 characters

1 Answers  


ORA-30460: 'string.string' cannot be refreshed because it is marked UNUSABLE

1 Answers  






ORA-12523: TNS:listener could not find instance appropriate for the client connection

1 Answers  


TNS-02524: Authentication: privilege check failed

1 Answers  


QSM-02162: the detail table does not have a materialized view log

1 Answers  


TNS-02401: gbname string too long, allowed number characters

1 Answers  


ORA-12025: materialized view log on "string"."string" already has primary keys

1 Answers  


ORA-32106: array fetch not allowed without setBuffer on all columns

1 Answers   Oracle,


ORA-12986: columns in partially dropped state. Submit ALTER TABLE DROP COLUMNS CONTINUE

1 Answers  


Categories