ASP -> ODBC -> Oracle7.3 using Longs

The problem: Using select/insert/update on long datatype fields from ASP pages to an Oracle7.3 DB. The error I'm getting is this:

Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC driver for Oracle][Oracle]ORA-01704: string literal too long

My questions:

1. How can I select/insert/update long datatype fields using ASP pages and Microsoft's Oracle ODBC driver bundled in MDAC2.0?
2. I've read that there is a 32K data limitation using ODBC drivers and Oracle. Is this true? Is it an ODBC limitation? I've been able to use ASP
   -> ODBC -> Access with Memo fields and had no problems (or programming
   workarounds) to select/insert/update large blocks of text.
3. Is there a way to connect directly from ASP -> Sql*Net -> Oracle7.3? The DB I'm using sits on the same server as the IIS4.

Any help would be greatly appreciated!

Thanks :)

leslie

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sun Feb 07 1999 - 14:13:25 CST