Hello Experts,

I have report to display data about employee and data contains image ,

that report was working fine when i was executing the report with oracle apps 11i and data type was LONG RAW for image field

whereas when i transfered into oracle apps R12 the IMAGE column data type in PER_IMAGES table is BLOB

Can anyone help me clearly to write the the main select in order to display image in the report.

main select :

 [/left]


[left]select  k.parent_id,k.image
from
per_images k
[/left]

Thanks in advance

السلام عليكم

U can do it this way

Step1: select the data in BLOB d/b column into a BLOB variable.

Step2: Use "dbms_load.read(lob_loc IN BLOB,amount IN OUT BINARY_INTEGER,offset IN INTEGER,buffer OUT RAW)" to read the data in BLOB variable into a RAW variable.

Step3: Insert the value in RAW variable (buffer) in to another table with a LONG RAW column. (The data in a RAW variable can be inserted into a LONG RAW d/b column).

Hope this servers your purpose.

وعليكم السلام ورحمة الله وبركاته

It's Worked , i appreciation that

Thanks very much!!!

worked with my way or another way ?

and please post the solution if its a different way

It worked By your way that you posted

Thank you for a helping

تم تعديل 31 مايو 201213 سنة بواسطة malik alwadi

Good

So, post the full code you used if that possible