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-01904: DATAFILE keyword expected

1 Answers  


ORA-13287: can't transform unknown gtype

1 Answers  


LSX-00121: value is not valid restriction of parent's length

1 Answers  


ORA-29390: some resource plans are not part of any top-plan

1 Answers  


ORA-02823: Buffer is not aligned.

1 Answers  






ORA-00058: DB_BLOCK_SIZE must be string to mount this database (not string)

1 Answers  


ORA-02309: atomic NULL violation

1 Answers  


ORA-10653: Table is in a cluster

1 Answers  


PLS-00353: 'string' must name a user in the database

1 Answers  


PCC-02369: An EXEC TOOLS host pointer variable is not a pointer

1 Answers  


ORA-26527: local store callback init phase failed for 'string.string'

1 Answers  


ORA-19508: failed to delete file "string"

1 Answers  


Categories