Hi there,

Have you checked which version of Oracle client is on the machine that is playing up?

I have had this problem from time to time, and have never nailed it down accurately. My current theory is that it is related to some versions of Oracle client (esp Oracle 7). You may recall that Oracle 7 had a maximum VARCHAR size of 2000. Putting Oracle 7 client together with Oracle 8i server sometimes gets confused and tries to convert the VARCHARs into LONGs or something like that.

Les

>Hello,
>
>I just moved all of the "memo" fields in an oracle table to varchar2(4000) and on my machine I can edit and save all day with no errors (I have a routine that checks for size of text and truncates it to 4000 or whatever the varchar2() size is).
>
>A client has the same routine and on "problem" page there are five memo fields (they went with some smaller sizes than 4000 on some of the fields)
>

>reportto   varchar2(1000)
>ccto       varchar2(1000)
>premable   varchar2(4000)
>bodyoftext varchar2(4000)
>close_text varchar2(2000)
>

>
>If they edit one field (cut and paste a field with more than 5000 characters in it) and save it it -- no problems. If they enter the same text in all five fields and hit save, Tableupdate(.t.) returns .f. and they get the error:
>

>The Error messages are 'Saving of Audit Data Failed'; and '[MICROSOFT][ODBC
>DRIVER FOR ORACLE][ORACLE]ORA-01026: MULTIPLE BUFFERS OF SIZE > 4000 IN THE
>BIND LIST'.
>

>
>The truncation down to 4000 or 1000 or whatever seems to work just fine.
>
>They have MS ODBC for Oracle driver: 2.573.4403.00 while I have 2.573.3711.00. Any ideas on what maybe happening?? -- using VFP6 SP3 dev and Runtime. My next steps will be to
>a) have them install the exact ODBC driver I am using; then I might try
>b) using sql pass-thru instead on updating a remote view.
>
>Of course, it works fine on my machine, which always makes things difficult to fix when you can't reproduce it yourself.
>
>Thanks for any ideas,
>
>Kevin