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-12918: Invalid tablespace type for default permanent tablespace

1 Answers  


ORA-02315: incorrect number of arguments for default constructor

1 Answers  


ORA-09835: addCallback: callback port is already in a set.

1 Answers  


ORA-12062: transaction string received out of sequence from site string

1 Answers  


ORA-07484: snlkput: cannot convert(put) lock.

1 Answers  


NID-00304: Datafile string - reverted

1 Answers  


TNS-12532: TNS:invalid argument

4 Answers  


ORA-00991: only MAC privileges may be granted to procedures

1 Answers  


TNS-00061: INTCTL: Bad command or syntax error: You must specify a trace level

1 Answers  


ORA-33074: (XSAGDNGL36) In AGGMAP workspace object, the offset number is not a valid offset into dimension workspace object.

1 Answers  


ORA-23314: database is not a materialized view site for "string"."string"

1 Answers  


NID-00140: Specified database name string does not match previous name used string

1 Answers  


Categories