| open pdf file thru oracle forms developer 9i and extract blob from DB thru forms [message #460678] |
Mon, 14 June 2010 02:21  |
sunayani
Messages: 1
Registered: June 2010
|
Junior Member |
|
|
Sir,
I have a table in oracle image_table_2
IMAGE_ID NUMBER(38)
FILE_NAME VARCHAR2(100)
IMAGE_DATA BLOB
Through sqlldr I have loaded following data
1,x.pdf, c:\x.pdf
2,y.pdf, c:\y.pdf
When i give command at sql
sql> select image_id, file_name, DBMS_LOB.GETLENGTH(image_data)
from image_table_2
it gives
1 52283
2 310300
It does not show the filename. has data been loaded properly?
My second question is how to open the blob field in Forms? I am using Oracle 10g. I have gone thru so many URLs for that but didn't get a perfect answer.
I just developed a simple form for that. For the blob field what should be defined in the property?
Item Type Image
Image Format - what should be there . pdf is not there
Pl help me out.Kindly help me with the code. do not give any solution like bfile or something as we are not so conversant with that.
Thanks in advance
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
