Home » Developer & Programmer » JDeveloper, Java & XML » BLOB Question in Oracle 9i
BLOB Question in Oracle 9i [message #91647] Fri, 27 December 2002 03:25 Go to next message
Ehsan Khosrowshahi
Messages: 1
Registered: December 2002
Junior Member
Ive got a problem inserting files larger than 2k (2048 bytes) into
BLOB objects via JDBC, i use something like this:

if (news.getPicture() != null)
ps.setBinaryStream(9,news.getPicture(),news.getPicture().available
());
else
ps.setBinaryStream(9,null,0);

suppose tht new.getPicture() returns a InputStream, it works fine
when the file size (InputStream) is less than 2k but it doesnt works
when it gets larger than 2k.

As im a newbie in JDBC programming i would appreciate any guides or
tips to solve my problem.

best regards
Ehsan
How to store image files into Oracle BlOB from PowerBuilder 6.5 [message #91693 is a reply to message #91647] Sat, 11 January 2003 07:10 Go to previous message
Paramesh
Messages: 3
Registered: January 2003
Junior Member
Hi,

I want to store image files into Oracle BLOB data type from PowerBuilder 6.5.

The code is:

updateblob [[table_name]] set [[column_name_1]] = [[Picture file]] where [[column_name_2]] = 1;

Please help me to solve this.

Thanks in advance.

Paramesh
Previous Topic: Multiple sql statement in 1 store procedure
Next Topic: JAVAand Microsoft SQL
Goto Forum:
  


Current Time: Tue Jul 27 22:18:18 CDT 2021