OraFAQ Forum: Reports & Discoverer » Dynamic image source

Home » Developer & Programmer » Reports & Discoverer » Dynamic image source (Report Builder 10.12 on Windows )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Dynamic image source [message #588651]

Thu, 27 June 2013 04:56

MahdiAbuHassan
Messages: 7
Registered: May 2013
Location: Bahrain

Junior Member

I have a report with image. The report works fine with the static image location but gives Error 40735 Ora:06502 with the URL dynamic image location. Please find below the image_formula trigger.

unction CF_imageFormula return Char is
temp_name varchar2(200 char);
in_file TEXT_IO.FILE_TYPE ;
begin

temp_name := 'RPD-11-018-033.jpg' ;

return '\appsys\roadcis\images\Tco\'||temp_name;

-- return 'http://10.40.115.23:8080/TestImage/FitchImage';

-- return null;

exception
when others then
return '\appsys\roadcis\images\layout.jpg' ;

end;

Where is my problem?

Report message to a moderator

Re: Dynamic image source [message #588666 is a reply to message #588651]

Thu, 27 June 2013 05:27

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What is "dynamic" in your code?

ORA-06502 suggests that URL (probably fetched from a table) doesn't fit into a variable or that you are trying to put a string into a NUMBER variable.

Without some more details (CREATE TABLE and INSERT INTO sample data, along with formula column code), it is difficult to say anything else.

Report message to a moderator

Re: Dynamic image source [message #588673 is a reply to message #588666]

Thu, 27 June 2013 05:49

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

That function can't give that error - the exception handler will catch it before you can see it.
So the error is coming from somewhere else.

Report message to a moderator

Re: Dynamic image source [message #589084 is a reply to message #588673]

Tue, 02 July 2013 02:13

MahdiAbuHassan
Messages: 7
Registered: May 2013
Location: Bahrain

Junior Member

I have went through the below steps to get an image in may report but still it is not working:

3.6.7.1.13 Linking an image object to a URL

--------------------------------------------------------------------------------
Note:
This procedure is for HTML output only.

--------------------------------------------------------------------------------

To link an image object to a URL:

In the Paper Design view or Paper Layout view, click the Link File tool in the tool palette

Click and drag a rectangle.

Double-click the link file object to display the Property Inspector.

Under the Link File Boilerplate node:

set the Source File Format property to Image URL.

set the Source Filename property to the URL where the image is located with the required protocol.

Example 1
HTTP://www.oracle.com/images/logo.gif

Example 2
HTTP://&<P_SERVER_NAME>/images/logo.gif
where P_SERVER_NAME is a user parameter of type CHAR
At runtime, the end user can specify a value for the parameter (e.g., P_SERVER_
NAME = www.oracle.us.com for a dynamic URL link of
HTTP://www.oracle.us.com/images/logo.gif).

Example 3
FILE://c:/images/logo.gif

Attachment: My_Report.pdf
(Size: 124.08KB, Downloaded 2699 times)

[Updated on: Tue, 02 July 2013 02:18]

Report message to a moderator

Re: Dynamic image source [message #589085 is a reply to message #589084]

Tue, 02 July 2013 02:19

MahdiAbuHassan
Messages: 7
Registered: May 2013
Location: Bahrain

Junior Member

Report output is attached above and report setting is attached below

Attachment: Report_setting.jpg
(Size: 319.40KB, Downloaded 2025 times)

[Updated on: Tue, 02 July 2013 02:26]

Report message to a moderator

Re: Dynamic image source [message #589104 is a reply to message #589085]

Tue, 02 July 2013 04:59

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Unfortunately, you are right ... I didn't manage to display an image using the same walktrough either. I googled for the issue, but didn't find any answers (only questions). I visited My Oracle Support site, but they didn't record that "bug" either (or I couldn't locate it). Hopefully, someone else knows how to do that and will show us the way.

Report message to a moderator

Previous Topic:	Multiple record printing on same line no in oracle report10g
Next Topic:	SRW.ATTR must be declared

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 17:39:30 CST 2025