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

SQL-02125: Connect error, can't get error text

1 Answers  


ORA-32014: error processing parameter "string" from the SPFILE restore image

1 Answers  


PLS-00543: a PLSQL Table may not contain a nested table type or VARRAY.

1 Answers  


SQL*Loader-00805: %s not supported by External Table

1 Answers  


ORA-13707: Either the start snapshot string or the end snapshot string is incomplete or missing key statistics.

1 Answers  


LFI-00152: Read operation (byte mode) failed.

1 Answers  


ORA-22857: cannot modify columns of object tables

1 Answers  


ORA-13296: incorrect coordinate system specification

1 Answers  


NCR-04004: NCRR: Invalid interface instance handle

1 Answers  


ORA-01529: error closing file 'string'

1 Answers  


ORA-24330: internal OCI error

1 Answers  


DRG-51312: DML lock internal error string

1 Answers  


Categories