I have a problem that I hope someone can help me with. I need to insert a large quantity of data into an Oracle database using webMethods on Win2000. The database has several LONG VARCHAR2 fields. In the Oracle database, these fields should hold up to 2 gigabytes each, but when I try to insert the data using the webMethods $dbalias (URL is jdbc:oracle:thin:@bbe:1521:orcl) I get the following error:
Data size bigger than max size for this type: 7568
I’m wondering if the jdbc driver has some kind of data limit, and if so, how does one get around it?
Any help would be appreciated.