OraFAQ Forum: Forms » BLOB image is not saving.

Home » Developer & Programmer » Forms » BLOB image is not saving. (Oracle 9.2.0.1.0 ; Forms 6.0.1 , XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

BLOB image is not saving. [message #531047]

Sat, 12 November 2011 04:59

bluetooth420
Messages: 146
Registered: November 2011

Senior Member

Dear All,

I am failed to saved image in the table via forms.
(Although i have successfully updated the table with a procedure at PL/SQL level).

Here is what i have done.

1) Table created

create table prod 
(pcode number, 
image blob);

2) Made a form with help of guidence present at orafaq

3) It reads and saves image BUT enter/execute query does not show the image

4) even the following code gives me 0

select dbms_lob.getlength(image) from prod

Which thing am i missing?

Attachment: image.fmb
(Size: 52.00KB, Downloaded 1094 times)

Report message to a moderator

Re: BLOB image is not saving. [message #531048 is a reply to message #531047]

Sat, 12 November 2011 05:08

bluetooth420
Messages: 146
Registered: November 2011

Senior Member

i am attachimng the image in order to support the step-3 above.

(Amazingly, i have achieved my objective by using image column type "LONG RAW" instead of BLOB but i dont want to use it as LONG RAW is not being supported at PL/SQL level to upload image directly and Oracle resrticts it too)

Attachment: problem.JPG
(Size: 47.79KB, Downloaded 699 times)

Report message to a moderator

Previous Topic:	Display code errors above Form 10g!
Next Topic:	How to call java calender in oracle form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 06:05:13 CST 2025