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

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

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00250：参数子句中字符串的使用不正确。,
.原因：在参数子句中使用诸如MAXLEN，LENGTH，CHARSETID，CHARSETFORM RETURN之类的关键字不正确,
.操作：如果MAXLEN，LENGTH，TDO，DURATION，CHARSETID或CHARSETFORM等关键字不能与PL / SQL形式参数或形式参数的模式一起使用，则会发生此错误。例如，MAXLEN只能为CHAR或VARCHAR2 PL / SQL变量声明，并且仅对OUT或INOUT PL / SQL变量才允许使用MAXLEN。此外，在PL / SQL PROCEDURE的参数子句中指定了RETURN。例如CRATE PROCEDURE PROC是外部名称...图书馆...参数（返回指示符短，返回）;,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题