PLS-00215: 문자열 길이 제약은 (1 .. 32767)범위이어야 합니다
CREATE OR REPLACE PROCEDURE PROC_NAME
(
in1 IN VARCHAR2,
in2 IN VARCHAR2,
out1 OUT NUMBER
out2 OUT NUMBER
)
AS
var1 NUMBER;
var2 NUMBER;
var3 VARCHAR2; -- ERROR 11
BEGIN
...
END;
PROCEDURE created with compilation error.
11/13 PLS-00215: 문자열 길이 제약은 (1 .. 32767)범위이어야 합니다
VARCHAR2 -> VARCHAR2(1)
CREATE OR REPLACE PROCEDURE PROC_NAME
(
in1 IN VARCHAR2,
in2 IN VARCHAR2,
out1 OUT NUMBER
out2 OUT NUMBER
)
AS
var1 NUMBER;
var2 NUMBER;
var3 VARCHAR2(1);
BEGIN
...
END;
(
in1 IN VARCHAR2,
in2 IN VARCHAR2,
out1 OUT NUMBER
out2 OUT NUMBER
)
AS
var1 NUMBER;
var2 NUMBER;
var3 VARCHAR2; -- ERROR 11
BEGIN
...
END;
PROCEDURE created with compilation error.
11/13 PLS-00215: 문자열 길이 제약은 (1 .. 32767)범위이어야 합니다
VARCHAR2 -> VARCHAR2(1)
CREATE OR REPLACE PROCEDURE PROC_NAME
(
in1 IN VARCHAR2,
in2 IN VARCHAR2,
out1 OUT NUMBER
out2 OUT NUMBER
)
AS
var1 NUMBER;
var2 NUMBER;
var3 VARCHAR2(1);
BEGIN
...
END;
댓글
댓글 쓰기