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:chetan.minaj...@tcs.com] Sent: Friday, October 02, 2009 6:00 AM To: user-java@ibatis.apache.org 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: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org
