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-34901: (PPWKDAYS01) Blank lines are not allowed in the DAYNAMES option.

1 Answers  


PLS-01417: Use of %%attribute

1 Answers  


ORA-02145: missing STORAGE option

1 Answers   Oracle,


ORA-01757: Must specify an object number

1 Answers  


ORA-33218: (CINSERT04) %K is not a valid value for the workspace object dimension. Values for this dimension can have at most number significant digits after rounding to number decimal places.

1 Answers  


ORA-32334: cannot create prebuilt materialized view on a table already referenced by a MV

1 Answers  


ORA-40204: model string already exists

1 Answers  


ORA-01252: cannot prevent writes - file string in recovery manager backup

1 Answers  


IMG-00530: internal error while parsing command

1 Answers  


ORA-31469: cannot enable Change Data Capture for change set string

1 Answers  


ORA-29885: domain index is defined on the column to be modified

1 Answers  


ORA-07625: smsget: $MGBLSC failure

1 Answers  


Categories