CLOBs BLOBs and other monsters

Hi all,

Thanks for the help on the “exceeded oracle cursor allocation” problem. After futher examination, we have determined that our problems are a little deeper.

We implemented a custom interface into oracle using “classes12.zip” by importing the oracle specific jdbc objects in java services. We’ve used this for the last few months to manipulate CLOBs in Oracle. We also use this to obtain row IDs on return and some other similar types of functionality.

Well, our business has grown and this implementation is not scaling properly. We are having connection problem collisions among other things.

Can anyone tell us how we can leverage the existing “db” objects in webMethods to extend this type custom functionality?

We are seeking to obtain a row ID on an insert and the ability to insert a BLOB/CLOB.

Thanks for any and all help!

Ray