Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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-01561: failed to remove all objects in the tablespace specified

1 Answers  


PLS-01414: Use of qualified expression here

1 Answers  


ORA-27213: failed to unload Media Management Library

1 Answers  


ORA-00206: error in writing (block string, # blocks string) of controlfile

1 Answers  


ORA-32615: incorrect use of MODEL IS ANY predicate

1 Answers  


ORA-02147: conflicting SHARED/EXCLUSIVE options

1 Answers  


DRG-50608: unexpected end of data

1 Answers  


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

1 Answers   Oracle,


RMAN-11000: message number number not found in recovery manager message file

1 Answers  


ORA-14306: List value 'string' specified twice in partitions 'string', 'string'

1 Answers  


PLS-00603: GROUPING function supported only with GROUP BY CUBE or ROLLUP

1 Answers  


RMAN-08537: channel string: skipped, autobackup already found

1 Answers  


Categories