Re: Inserting LONG data into a table

In article <menezal.950213151422_at_mallard.duc.auburn.edu>, menezal_at_mallard.duc.auburn.edu (Alfred Menezes) writes:
|>
|> Could someone please tell me how to insert a string longer than 255 characters
|> into a "long" datatype in a database?
|>
|> More precisely, I have a simpe table
|>
|> create table junk (
|> type char(25),
|> description long
|> );
|>
|> When trying to insert something like
|>
|> insert into junk values ('list','12345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678|> 9012345678901234567890123456789012345678901234567890123456789012345678901234567890');
|>
|> I get an error message
|>
|> ERROR at line 1:
|> ORA-01704: string literal too long
|>
|>
|> Thanks in advance,
|> Alfred Menezes

Use Pro*C. You can then use insert into junk values ('list', :long_val) where long_val is a bind variable up to 2 GIG in length. Received on Wed Feb 15 1995 - 19:32:05 CET