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

DRG-50909: maximum number of documents string is not an integer

1 Answers  


ORA-29854: keyword BITMAP may not be used in creating domain indexes

1 Answers  


PCB-00206: Cannot use N quoted literal in PL/SQL when NLS_LOCAL=YES

1 Answers  


ORA-16644: apply instance not available

1 Answers  


ORA-01667: cannot add any more tablespaces: limit of string exceeded

1 Answers  


TNS-12150: TNS:unable to send data

1 Answers  


ORA-01218: logfile member is not from the same point-in-time

1 Answers  


ORA-09975: kxfspini: Error Initializing SDI Process

1 Answers  


ORA-19400: System type conflict with object SYS.string

1 Answers  


AMD-00160: Warning! Exceeded maximum Custom Measure number of "string"

1 Answers  


NNL-00255: Server-generated requests now request forwarding

1 Answers  


RMAN-20222: datafilename not found in recovery catalog or is ambiguous

1 Answers  


Categories