Dear experts....

 

I have already raised this problem a month back .. Still I have not got any solution. Please help.me.

 

I have a table called   t_pis_emp_photo_MST

 

Name                            Null?    Type
 ------------------------------- -------- ----
 EMPNO                           NOT NULL NUMBER(5)
 PHOTO                                    BLOB
 USERID                                   VARCHAR2(10)
 DATESTAMP                                DATE

 

Recently I have migrated the database from Oracle 9i to Oracle 10gR2 by taking export of 9i and importing to 10GR2. 

 

All the data have been imported. But I am not able to retrieve the photo (BLOB) field. I am retrieving  the photo field using forms 6i.  It throws an error saying ' unable to query records'.

 

Please help me to get the photo of each employee through forms6i .

 

Thanks in  ADVANCE

 

Regards

 

K.Karmegam

Kagithapuram



Oracle LazyDBA home page