I am not sure why you get the error, but LONG is what you should use which is the same as SQL Server TEXT data type. Long also would be the VFP memo field. Unlike VFP and SQL Server, you may only have 1 LONG data type per table. Can you get more specific error information using AERROR() right after you get this error?
>I get the following error
>
>Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
>[Oracle][ODBC]Function sequence error.
>
>When I try to update an Oracle9i table that has a data type LONG in it [via ASP].
>
>Any ideas why?
>
>I am using a LONG field as a replacement for SQL Server TEXT type - is
>this correct, or should I use another data type ?
>
>If we remove the LONG field, we don't get the error.
>
>Best.
>
>Matt.
Mark McCasland
Midlothian, TX USA