OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » long datatype

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

long datatype [message #52114]

Wed, 03 July 2002 03:05

Robert
Messages: 43
Registered: August 2000

Member

Hi all,

I like to insert a long string in a column with long datatype. When I insert it directly, I got the error message of ORA-01704: string literal too long. Then I try to use concatenated string or bind variable to insert, I got the error message of Input is too long (> 2499 characters).

If this cant be handled by long, would you suggest outer solution?

Thanks in advance.

Robert

Report message to a moderator

Re: long datatype [message #52119 is a reply to message #52114]

Wed, 03 July 2002 06:57

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Use a bind variable instead of a string literal.
I belevie,this can only be done with the precompilers or OCI.

Report message to a moderator

Re: long datatype [message #52125 is a reply to message #52119]

Wed, 03 July 2002 18:16

Robert
Messages: 43
Registered: August 2000

Member

In fact, I have tried to use PL/SQL

declare insert_text long := '<very long string>'

begin
execute immediate 'insert into my_table
(subject_id, body) values
(200, :insert_text_bv)'
using insert_text;
end;
/

But I still got error of Input is too long (> 2499 characters).

Report message to a moderator

Previous Topic:	checkpoint not complete reg.
Next Topic:	Improve Sort Perf. Through SORT_AREA_SIZE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 12 18:21:32 CST 2025