Oracle Reports (MOSC)

MOSC Banner

unable to read data in image format

edited Aug 22, 2013 1:49AM in Oracle Reports (MOSC) 5 commentsAnswered ✓
 Dear All,
My requirement is to display employee image along with data. for this i have created below query

select f.employee_number,f.full_name,f.national_identifier,f.date_of_birth,f.original_date_of_hire,f.person_id,f.person_type_id,i.image 
from Per_All_People_f f,per_images i
where f.person_id = i.parent_id
---and f.person_id = 76---1207
and sysdate between f.effective_start_date and f.effective_end_date

but problem is that, at the time of execution report fails with subjected error.
we have already changed file format property to "image" but problem remain persists. any idea?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center