We are facing a peculiar problem regarding stored procedure :
The stored procedure is called via an adapter service and output of the stored procedure is an XML.
The problem is sometimes the adapter service gives an incomplete XML and sometimes it gives a proper XML. Running the stored procedure individually gives the proper XML.
- Thin driver support : we are using 10g drivers which support large XML’s
- Output Field of Stored Procedure : Set to CLOB so that we get full XML
- JDBC Adapter version : 6.0.3 , IS 6.1 with SP1 and FP2 and Fixes
- Connection Pool Settings
Transaction Type -> LOCAL_TRANSACTION
DataSource Class -> oracle.jdbc.pool.OracleDataSource
Other Properties -> driverType=thin
Enable Connection Pooling -> true
Minimum Pool Size -> 0
Maximum Pool Size -> 30
Pool Increment Size -> 1
Block Timeout (msec) -> 10000
Expire Timeout (msec) -> 300000
Startup Retry Count -> 4
Startup Backoff Timeout (sec) -> 30
Please let me know if some setting which we have to do somewhere.