PL/SQL (MOSC)

MOSC Banner

DBMS_OUTPUT.PUT_LINE

edited Aug 10, 2009 3:47PM in PL/SQL (MOSC) 6 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center