Home » SQL & PL/SQL » SQL & PL/SQL » long data type : 4k or 2GB
long data type : 4k or 2GB [message #2441] Tue, 16 July 2002 12:13 Go to next message
bwhale1
Messages: 4
Registered: January 2001
Junior Member
i tried to insert data into a table /w a long data type column. and kept error message :getting string literal too long.
based on "oracle concept" chapter 12: build-in data type. long is 2gb and LOB is 4gb.
it seems the long col only inserts up to 4kb. that is the max size of varchar2 , not the max size of long.
what is wrong there ?

thank in advance

Report message to a moderator

Re: long data type : 4k or 2GB [message #2444 is a reply to message #2441] Tue, 16 July 2002 15:40 Go to previous message
marwan
Messages: 1
Registered: July 2002
Junior Member
Use ADO's appendChunck. Long does support 2GB. OLEDB provider doesn't support more that 4K for insert/update operations.

Report message to a moderator

Previous Topic: Re: VVVVVry urgent :server name for crystal reports
Next Topic: Setting Oracle environment
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 09 14:14:02 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.