Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.
We are actually trying to insert NCLOB into Oracle 10 g DB using the Stored Procedure Template of webMethods but we received the “Invalid Column Type” error We are using JDBC Adapter 6.0.3 - Feature Pack 1 - Fixes 7, 9 & 10. We are using the Oracle Thin Driver with Datasource Class = oracle.jdbc.pool.OracleDataSource. If any one can provide some solution that will be good.
I also have the same problem when trying to insert large size of data using the webMethods built in JDBC Adapter but succeeded when using a custom java service (using Oracle Driver). So for this case i would like to suggest you to write your own java service that insert to your Database.
Hi,
Thanks For Replying. Can you provide me with the Java Service you had written for reference. This will be a great help.
Thanks, Himanshu
Did you try oracle 10g drivers. copy n paste :
into “/IntegrationServer/packages/WmJDBCAdapter/code/jars/static/”
Hope it helps.
Regards, Sumit