Hello All,

Im having an issue in inserting Data ( more than 28KB) to a table for column type BLOB(column size specified as 4000). I know BLOB holds upto 2GB of Data.
Im getting the below error in server logs

Server log:
B Data size bigger than max size for this type: 34140"[/b]
Data size bigger than max size for this type: 34140

Data base: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
Wm verion : 6.5 SP 3
Driver: Classes12.zip (1936596) , ojdbc14.jar( 1555682)
Java Verion:
Java Version 1.4.2_11 (48.0)

Flow service is failing in runtime in which im invoking the JDBC stored procedure…but when imanually run the JDBC stored procedure by passing the parameters, it is able to insert the large data into table…

i checked advantage webMethods…simillar case happend but the resolution was not that clear…

[url]https://empower.softwareag.com/eservice/kb/?id=00000000001A40E2[/url]

Waiting for your valuable suggestions…

Thanks in Advance
Prasad

This is may be due to Bind variables limit on PL/SQL

bind variables passed to a program unit
32768