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-19693: backup piece string already included

1 Answers  


ORA-38757: Database must be mounted EXCLUSIVE and not open to FLASHBACK.

1 Answers  


QSM-01081: no primary key or row id found for table, string, in MV, string

1 Answers  


ORA-28021: cannot grant global roles

1 Answers  


LSX-00154: attribute "use" must have its value set to "optional"

1 Answers  


ORA-24034: application string is already a subscriber for queue string

1 Answers  


ORA-25532: MTTR specified is too large: string

1 Answers  


QSM-01062: query has one or more manual partition(s)

1 Answers  


ORA-38437: The ADT "string" may not contain any user methods.

1 Answers  


ORA-30074: GLOBAL partitioned index on TIME/TIMESTAMP WITH TIME ZONE not allowed

1 Answers  


ORA-12350: database link being dropped is still mounted

1 Answers  


ORA-32152: Cannot perform operation on a null number

1 Answers  


Categories