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-22980: must specify a set of attributes for the WITH OBJECT OID clause

1 Answers  


NNL-00282: Cancelled restart

1 Answers  


ORA-12407: unauthorized operation for policy string

1 Answers  


ORA-06573: Function string modifies package state, cannot be used here

1 Answers  


RMAN-08538: channel string: no autobackup in string days found

1 Answers  


LFI-00122: Can only delete a file if we create it.

1 Answers  


ORA-02458: HASHKEYS must be specified for a HASH CLUSTER

1 Answers  


TNS-01073: Listening on: string

1 Answers  


DRG-52100: %(1)s returned internal error code string

1 Answers  


TNS-01096: %s * string * string * string * string * number

1 Answers  


ORA-33448: (ESDREAD04) Discarding compiled code for workspace object because number now has string data, whereas it had string data when the code was compiled.

1 Answers  


ORA-07266: sppst: invalid process number passed to sppst.

1 Answers  


Categories