Home » Developer & Programmer » Forms » Help me as soon as possible for error :=ORA-01026 multiple buffers of size > 4000 in the bind list
Help me as soon as possible for error :=ORA-01026 multiple buffers of size > 4000 in the bind list [message #85098] Tue, 01 June 2004 12:59 Go to next message
Muhammad Aurangzaib
Messages: 43
Registered: April 2003
Member
Salam

Hope all are best in yu health....

I am facing a problem on developer 2000 (form 6i).. I am using BLOB (Image / MS-Word) and two database items varchar2(4000)on form, when i do DML opration on this block the error occurs as:

ORA-01026 multiple buffers of size > 4000 in the bind list

Please help me as soon as possible... and also guide me about the backgroud of this error.

 

thx a lot

itroome@hotmail.com

aurangzaib@hotmail.com

 
Re: Help me as soon as possible for error :=ORA-01026 multiple buffers of size > 4000 in the bind li [message #85103 is a reply to message #85098] Wed, 02 June 2004 01:56 Go to previous messageGo to next message
Himanshu
Messages: 457
Registered: December 2001
Senior Member
Hi,
Which DB are you using?
There can be many things which may cause this error which are:
1.Bug related to ODBC driver.
2.NLS_LANGUAGE settings.
3.Buffer size of Sql (Forms bug).

One of the solution may be to write the DML in On-insert/update triggers of the block, if this is due to #3.

If it is due to #2 then
You should set the main NLS_LANG (HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE) at you registry to have the same value as your database is (probably UTF8). For example AMERICAN_AMERICA.UTF8 instead of AMERICAN_AMERICA.WE8ISO8859P1 or HEBREW_ISRAEL.UTF8 instead of HEBREW_ISRAEL.IW8ISO8859P8.

HTH
Regards
Himanshu
Re: Help me as soon as possible for error :=ORA-01026 multiple buffers of size > 4000 in the bind li [message #85112 is a reply to message #85103] Wed, 02 June 2004 13:05 Go to previous message
Muhammad Aurangzaib
Messages: 43
Registered: April 2003
Member
Salam

Hope u are best in yu health....

I am using oracle 8.1.7 ... would u explin me in detail now...

thx

itroome@hotmail.com
Previous Topic: Forms 10g and Oracle 10g
Next Topic: background colour.
Goto Forum:
  


Current Time: Wed May 01 10:27:13 CDT 2024