Hi all

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.

Nancy

Hi, Nancy.

You may want to read over these threads. They cover similar problems and present workarounds.

[*]BLOBs --[url="http://www.wmusers.com/wmusers/messages/117/488.shtml"]http://www.wmusers.com/wmusers/messages/117/488.shtml[/url] [*]More on BLOBs -- [url="http://www.wmusers.com/wmusers/messages/117/941.shtml"]http://www.wmusers.com/wmusers/messages/117/941.shtml[/url] [*]Large Database Fields -- [url="http://www.wmusers.com/wmusers/messages/117/784.shtml"]http://www.wmusers.com/wmusers/messages/117/784.shtml[/url] [*]Oracle and Binary data -- [url="http://www.wmusers.com/wmusers/messages/117/1014.shtml"]http://www.wmusers.com/wmusers/messages/117/1014.shtml[/url] [/list]

Thanks.

Thanks, Dan.

I did look over those postings. I don’t need to store a BLOB or CLOB of binary data, I’m just inserting text.

After some experimentation, I discovered that the thin client (jdbc:oracle:thin) is the problem. I switched to a Type 2 driver, (jdbc:oracle:oci8) and everything worked!

I didn’t need to write any java code, just set up the data record and used the pub.db:insert in the WmDB package.