| Problem with BLOB Data. [message #118769] |
Sun, 08 May 2005 06:03  |
sohailnawaz
Messages: 40
Registered: April 2005
Location: Saudi Arabia
|
Member |
|
|
Suppose Here is my table Below
SQL>DESc P
SNO NUMBER,
PIC BLOB.
NOw in this table i want to insert values through Form. How can i insert records in this table through Form. I am trying but record is not saving in BLOB field.
ON Browse command button my code is
Declare
filename varchar2(200);
Begin
filename:=get_file_name('c:\pict','*.TIFF');
read_image_file(filename,'TIFF','PIC');
End;
Tell me what is wrong with this.
Thanks
|
|
|
|
| Re: Problem with BLOB Data. [message #119028 is a reply to message #118769] |
Tue, 10 May 2005 06:16  |
subba lakshmi
Messages: 36
Registered: March 2005
|
Member |
|
|
1.create table sl_img(eno number(3),empimg clob);
2.create a form using control block.
3.take two text boxes -
(i) one text box data type char and max.length 30
(ii) other text box data type long and max.length 240
4.take a image item(image4)
on post-text-item of (ii) write this code
read_image_file(:sl_img.empimg,'bmp','sl_img.image4');
5.take push button
on when-button-pressed write
insert into sl_img values(:sl_img.eno,:sl_img.empimg);
commit;
6.while selecting include this statement to show image onto image item.
write_image_file(:sl_img.empimg,'bmp','sl_img.image4');
from
subba lakshmi
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
