| BLOB data is not saving through Form 6.0. [message #118766] |
Sun, 08 May 2005 04:32  |
sohailnawaz
Messages: 40
Registered: April 2005
Location: Saudi Arabia
|
Member |
|
|
Picture data is not inserting through Form 6.0. Actually in my database in BLOB filed I wast to store signatures.
on command button Browse my code is :
Declare
filename varchar2(200);
Begin
filename:=get_file_name('c:\pict','*.tiff');
read_image_file(filename,'TIFF','PIC');
end;
When i am saving record message display "One record applied and saved successfully" But when i am querying the record (F8). then Picture Data is not showing in BLOB filed. when i am using DBMS_LOB.GETLENGTH(pic) then length is showing zero (0). it means data is not saving in BLOB filed. How can i save data in BLOB filed through From 6.0.
Thanks
|
|
|
|
| Re: BLOB data is not saving through Form 6.0. [message #163957 is a reply to message #118766] |
Mon, 20 March 2006 23:27  |
amolnk
Messages: 9
Registered: March 2006
Location: India
|
Junior Member |
|
|
| Quote: |
Declare
filename varchar2(200);
Begin
filename:=get_file_name('c:\pict','*.tiff');
read_image_file(filename,'TIFF','PIC');
end;
|
I assume, PIC is your block name, provide the blob item in read_image_file as,
read_image_file(filename,'TIFF','PIC.sign_photo');
where sign_photo is the item in your PIC block.
Saving the record earlier, would have caused only the id to be saved.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
