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-00508: The expression in a RETURN statement cannot be a type



PLS-00508: The expression in a RETURN statement cannot be a type..

Answer / guest

Cause: A datatype specifier was used instead of an
expression in the RETURN statement of a user-defined
function, as shown in the example below. Do not confuse the
RETURN statement, which sets the function identifier to the
result value, with the RETURN clause, which specifies the
datatype of the result value. FUNCTION credit-rating
(acct_no NUMBER) RETURN BOOLEAN IS BEGIN ... RETURN NUMBER;
-- should be an expression END;

Action: Replace the datatype specifier in the RETURN
statement with an appropriate expression.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02399: exceeded maximum connect time, you are being logged off

1 Answers  


ORA-12845: failed to receive interinstance parallel execution message

1 Answers  


ORA-39018: master process received invalid message number string

1 Answers  


ORA-32005: error while parsing size specification [string]

1 Answers  


ORA-15102: invalid POWER expression

1 Answers  


SQL*Loader-00488: %s not a named collection type for filler field string

1 Answers  


ORA-12671: Shared server: adapter failed to save context

1 Answers  


PLS-00385: type mismatch found at 'string' in SELECT...INTO statement

1 Answers  


ORA-30018: Create Rollback Segment failed, USN string is out of range

1 Answers  


ORA-09819: Number exceeds maximum legal value

1 Answers  


ORA-12438: repeated policy option: string

1 Answers  


ORA-28590: agent control utility: illegal or badly formed command

1 Answers  


Categories