General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Long strings in Oracle
Hi All,
I'm using SQL pass-through to update an Oracle 8i database. Regardless of whether the field is defined as VARCHAR2(4000) or as a CLOB, I get an error when I try to update the field with a memo longer than 2000 characters. Is there a simple way around this, or do I have to create a stored procedure and build the field up using DBMS_LOB.WRITEAPPEND(). Any help would be appreciated.
Thanks
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only