| BLOB data is not showing on Query. [message #118139] |
Tue, 03 May 2005 04:08  |
sohailnawaz
Messages: 40
Registered: April 2005
Location: Saudi Arabia
|
Member |
|
|
I want to Insert a picture in BLOB data field. The Structure of my table is below.
SQL> desc p
Name Null? Type
----------------------------------------- -------- -----------
PIC BLOB
SNO NUMBER(4)
And through FROMS i am trying to insert record.
Behind command button my coding is.
DECLARE
FILENAME VARCHAR2(100);
BEGIN
FILENAME:= GET_FILE_NAME('C:\Pict\','*.TIFF');
:PICPATH :=FILENAME;
READ_IMAGE_FILE(FILENAME,'TIFF','PIC');
END;
Record is saving successfully but when i am going to query the record then picture data is not showing in BLOB field. Any body can help me.
Thanks
|
|
|
|
| Re: BLOB data is not showing on Query. [message #118201 is a reply to message #118139] |
Tue, 03 May 2005 10:58  |
Steve Corey
Messages: 336
Registered: February 2005
Location: RI
|
Senior Member |
|
|
How are you querying the record? In Forms? What type of object are you using to house the image? I think you may want to try OLE container dependant on the version of Forms you are using. This is just a stab in the dark considering the lack of environment information you have provided.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
