DBMS_OUTPUT.PUT_LINE
Hi,
DECLARE
v_Str1 VARCHAR2(32000);
BEGIN
v_Str1 := lpad(' ',32000,'A');
DBMS_OUTPUT.PUT_LINE(v_Str1);
END;
The above code runs fine in SQLPLUS connecting to 10G server. But the same code will fail on other GUI client tools with the following error
ORA-06502: PL/SQL: numeric or value error: host bind array too small
ORA-06512: at line 1
I am using sqltools downloaded from www.sqltools.net
Any idea?
Thanks,
Sha
DECLARE
v_Str1 VARCHAR2(32000);
BEGIN
v_Str1 := lpad(' ',32000,'A');
DBMS_OUTPUT.PUT_LINE(v_Str1);
END;
The above code runs fine in SQLPLUS connecting to 10G server. But the same code will fail on other GUI client tools with the following error
ORA-06502: PL/SQL: numeric or value error: host bind array too small
ORA-06512: at line 1
I am using sqltools downloaded from www.sqltools.net
Any idea?
Thanks,
Sha
0