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-00250: Incorrect Usage of string in parameters clause.



PLS-00250: Incorrect Usage of string in parameters clause...

Answer / guest

Cause: The usage of Keywords such as MAXLEN, LENGTH,
CHARSETID, CHARSETFORM RETURN in the parameters clause was
incorrect

Action: This error occurs if keywords like MAXLEN, LENGTH,
TDO, DURATION, CHARSETID, or CHARSETFORM cannot be used with
PL/SQL formal parameters or the mode of the formal
parameter. For example, MAXLEN can only be declared for a
CHAR or VARCHAR2 PL/SQL variable and its use is allowed only
for OUT or INOUT PL/SQL variables. Also, RETURN was
specified in the parameters clause for a PL/SQL PROCEDURE.
E.g. CREATE PROCEDURE proc IS EXTERNAL NAME ... LIBRARY ...
PARAMETERS(RETURN INDICATOR SHORT, RETURN);

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-14161: subpartition number string: sum of PCTUSED and PCTFREE may not exceed 100

1 Answers  


ORA-29555: Java source, class or resource is not allowed here

1 Answers  


ORA-01628: max # extents (string) reached for rollback segment string

1 Answers  


ORA-12404: invalid privilege string: string

1 Answers  


PCB-00003: Value of DBMS option invalid with given value of MODE option

1 Answers  


AMD-00108: Dimension "string" is improperly mapped; the dimension has string hierarchies mapped, but hierarchy level "string" has string columns mapped

1 Answers  


ORA-19731: cannot apply change to unverified plugged-in datafile string

1 Answers  


NCR-03004: NCRO: Unknown message

1 Answers  


IMP-00098: INTERNAL ERROR: string

1 Answers  


TNS-01018: save_config [<listener_name>]: saves configuration changes to parameter file

1 Answers  


ORA-22275: invalid LOB locator specified

1 Answers  


TNS-00093: argument is only supplied to either status or trace_on

1 Answers  


Categories