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-00372: In a procedure, RETURN statement cannot contain
an expression



PLS-00372: In a procedure, RETURN statement cannot contain an expression..

Answer / guest

Cause: In a procedure, a RETURN statement contains an
expression, which is not allowed. In functions, a RETURN
statement must contain an expression because its value is
assigned to the function identifier. However, in procedures,
a RETURN statement simply lets you exit before the normal
end of the procedure is reached.

Action: Remove the expression from the RETURN statement, or
redefine the procedure as a function.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

DRG-12006: Plase enter account:

1 Answers  


ORA-23395: object "string"."string" of type "string" does not exist or is invalid

1 Answers  


O2I-00117: Internal error: No message file for component O2U

1 Answers  


ORA-24777: use of non-migratable database link not allowed

1 Answers  


RMAN-08058: replicating controlfile

1 Answers  


ORA-30658: attempt was made to create a temporary table with EXTERNAL organization

1 Answers  


ORA-29892: indextypes with array DML do not support the given data type

1 Answers  


PROT-00707: Cluster registry integrity check failed

1 Answers  


NID-00311: Control File string - modified

1 Answers  


ORA-31406: change source string is referenced by a change set

1 Answers  


ORA-14016: underlying table of a LOCAL partitioned index must be partitioned

1 Answers  


ORA-10634: Segment is already being shrunk

2 Answers  


Categories