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

LPX-00219: invalid digit '~c' in character reference

1 Answers  


NNO-00613: disabling FORWARDING-DESIRED on system queries

1 Answers  


PLS-00631: PARTITION-BY and CLUSTER/ORDER-BY clauses must be used with the same function argument

1 Answers  


NPL-00419: received ASN.1 object identifier with sub-identifier that is too large

1 Answers  


RMAN-06128: skipping inaccessible file string

1 Answers  


RMAN-05010: target database must be opened in READ WRITE mode for TSPITR

1 Answers  


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

1 Answers  


PCC-02451: Value of offset cannot be negative in ABSOLUTE orientation mode

1 Answers  


NID-00131: Control file is not current

1 Answers  


ORA-09928: Unable to restore the label of server

1 Answers  


SQL*Loader-00408: Physical record stack overflow

1 Answers  


ORA-01222: MAXINSTANCES of string requires MAXLOGFILES be at least string, not string

1 Answers  


Categories