Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-02792: Unable to fstat() a file being used for asynchronous I/O.

1 Answers  


RMAN-04010: target database Password:

1 Answers  


ORA-28605: bitmap indexes cannot be reversed

1 Answers  


NZE-28861: SSL connection would block

1 Answers  


NZE-28838: no identity descriptor

1 Answers  






ORA-23355: object string.string does not exist or is invalid at master site

1 Answers  


TNS-04079: Cannot administer Oracle Connection Manager with no CMAN.ORA, and port = number.

1 Answers  


ORA-30944: Error during rollback for XML schema 'string' table string column 'string'

1 Answers  


PCC-02010: found end-of-file while scanning string literal

1 Answers  


DRG-50940: parser not parsed

1 Answers  


NZE-29018: The premaster secret contains an incorrect version number.

1 Answers  


ORA-12995: no columns in partially dropped state

1 Answers  






Categories