ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Givler, Eric" <egiv...@state.pa.us>
Subject RE: cannot retrieve a blob using a callable statement.
Date Fri, 02 Oct 2009 12:09:35 GMT
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.minajagi@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-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message