Oracle Reports (MOSC)

MOSC Banner

diplaying Image by specifying path

edited Jul 29, 2012 11:26PM in Oracle Reports (MOSC) 6 commentsAnswered
Hi,

I am calling image in reports by specifying path in formula column.  If image is not available in server in specified location. how to pass default message or default image.

Formula column:

function CF_IMAGEFormula return Char is
  lv_Image  Varchar2(200);
begin
  lv_Image := '/dbapp/db/EBSCRP/ebscrpcomn/java/oracle/apps/media/'||:employee_Number1||'.gif';
  Return(lv_Image);
end;

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