Command Window set

[admin]

I try to insert a long definition string - ~3000 characters - into a table column varchar2(4000). In SQL Plus - I get an error: 'SP2-0027: Input is too long (> 2499 characters) - line ignored'. When I do the same in PL/SQL Command Window everything is okay, no errors.
Is it Command Window set I would apply in SQL Plus or is it something else?

 

[Marco Kalter]

I'm not sure, but I think this is a hard 2500 character limitation. You may need to rewrite the insert statement so that all lines are less than 2500 characters.

 

[admin]

So how come it works fine in Command Window of PL/SQLDeveloper? I can insert a string longer than 2499 characters there without any problems. Is it done 'something' behind the scene?

 

[Marco Kalter]

It is a restriction of the SQL*Plus application, not a restriction of the Oracle Server. PL/SQL Developer does not use SQL*Plus, but talks directly to the Oracle Server.