Why do I get SP2-0253

Question

I am getting in my test. But I think linesize is already large enough. I know increase linesize will solve the issue. Please let me know why I am getting SP2-0253 here.

SQL> COLUMN sal  HEADING 'Salary' FORMAT $99,999.99
SQL> set lines 10
SQL> show user
USER is "SCOTT"
SQL> desc sal from emp
Usage: DESCRIBE [schema.]object[@db_link]
SQL> select sal from emp where rownum = 1;
SP2-0253: data item 1 ("SAL") will not fit on line
SQL> set lines 20
SQL> /

 Salary
-----------
$800.00

SQL>

Answer 1

1) show linesize to get the current linesize. My guess is "80".

2) set linesize 32767

3) Run your SQL command. Check the actual line size.