I like to know any of you have experience to handle Blob field of an Oracle table such as insert, select and update uinsg the built-in DB services.
I am trying to insert a binary file to a Blob column called PICTURE. I have create a db alias for all the connection information. My simple flow service is like this:
(1) pub.file:getFile: map the service out parameter body.bytes to a pipeline out parameter called PICTURE defined as an object type.
(2) pub.db:execSQL: this is generated by using Server Administrator’s “generating from table”. It generates dbParamType as OTHER for PICTURE.
When I run it, it works fine with a small file (< 1 K), but once I use a bigger file (30+ K). I always get “java.sql.SQLException: Io exception: Connection aborted by peer: socket write error”.
I try to change the dbParamType to other type, but then I always get Invalid Column exceptin.
I like to know if any of you have similar experience using built-in service. Or perphaps I need to write Java Service to handle this case.