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-39308: application/database upgrade internal error: "string"

1 Answers  


ORA-03231: the INITIAL extent may not be deallocated

1 Answers  


ORA-16752: Resource guard could not mount standby

1 Answers  


ORA-32100: operation invalid on transient object

1 Answers  


ORA-19764: database id string does not match database id string in control file

1 Answers  


PCC-02129: CMD-LINE: Client supplied static options table is invalid

1 Answers  


LPX-00275: can't set output/data encoding AFTER parsing

1 Answers  


ORA-39754: FULL PARTITIONED OUTER JOIN is not supported

1 Answers  


NCR-03008: NCRO: Call rejected

1 Answers  


ORA-32696: HTI: No free slot

1 Answers  


DRG-12800: Attribute NESTED_TYPE must have owner name as prefix

1 Answers  


ORA-19726: cannot plug data [string] at level string into database running at compatibility level string

1 Answers  


Categories