This is something we've struggled with on our team. AFAIK, Oracle's JDBC drivers do not support the passing of BLOB data in excess of 32K through a stored procedure, at least with the drivers that are included with Oracle A/S 10.1.2. You might try downloading a newer version of the drivers first and see if that works, provided you even have the option of changing the driver in your runtime environment (you won't with Oracle A/S).
In the meantime, I'll try and look for an example that attempted to do this. I don't see why it would be an issue to READ the blob with a simple SELECT? Later, Eric -----Original Message----- From: M V Chetan [mailto:[email protected]] Sent: Friday, October 02, 2009 6:00 AM To: [email protected] Subject: Re: cannot retrieve a blob using a callable statement. I have been looking around for examples for using CLOB/BLOB through a stored proc.Can anyone share a working example.Btw,I'm using Ibatis 2.3 Regards, Chetan -- View this message in context: http://www.nabble.com/cannot-retrieve-a-blob-using-a-callable-statement.-tp23174503p25713249.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
