alling stored procedure via adapter service gives inconsiste

, ,
1

Hi All,

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.

Configurations :

  1. Thin driver support : we are using 10g drivers which support large XML’s
  2. Output Field of Stored Procedure : Set to CLOB so that we get full XML
  3. JDBC Adapter version : 6.0.3 , IS 6.1 with SP1 and FP2 and Fixes
  4. Connection Pool Settings

Transaction Type → LOCAL_TRANSACTION
DataSource Class → oracle.jdbc.pool.OracleDataSource
networkProtocol →
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.

Regards,
Sumit

2

The OCI driver is recommended for use with CLOB’s over 4k. Perhaps that is your issue.
Mike

3

Hi Mike,

Oracle 10g drivers eliminates the need of OCI driver as it can support XMLs more than 4K.

We are using the same 10g drivers.

Regards,
Sumit