Inserting lengthy char data

[madhes]

Hi,

I need to insert a lengthy text into the columns of a table.

The format of the table is
int, char(2000), char(2000).

When i insert using the following statement,
&quot;insert into t1 values (1, <2000 characters>, <2000 characters>)&quot;,
it gives the following error:
&quot;SP2-0027: Input is too long (> 2499 characters) - line ignored&quot;

But, when i insert using preparedStatement from JDBC it works.
pst = con.prepareStatement(&quot;insert into chainTest values (2, ?, ?)&quot;
pst.setString(1, longText); // longText is a String with 2000 chars
pst.setString(2, longText);
pst.executeQuery();

Is there a way to reduce the size of the query, using something similar to replicate('#', 80), which produces 80 #s.

tia,
madhes

 

[sem]

Try to use bind varables:

var p1 varchar2(2000)
var p2 varchar2(2000)
exec 1:='...'
exec 2:='...'

insert into t1 values (1, 1, 2)

 

[madhes]

Oh! thanks a lot Sem! It works fine.

but, still i need to type 2000 characters. In case if want to insert some junk value, is there way to tell
&quot;put '#' 2000 times&quot; ?

thanks,
madhes

 

[sem]

Yes, you may use rpad('#', 2000, '#')

 

[madhes]

Thanks Sem!