Home » Developer & Programmer » Reports & Discoverer » Dynamic image source (Report Builder 10.12 on Windows )
Dynamic image source [message #588651] Thu, 27 June 2013 04:56 Go to next message
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?
Re: Dynamic image source [message #588666 is a reply to message #588651] Thu, 27 June 2013 05:27 Go to previous messageGo to next message
Littlefoot
Messages: 19894
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.
Re: Dynamic image source [message #588673 is a reply to message #588666] Thu, 27 June 2013 05:49 Go to previous messageGo to next message
cookiemonster
Messages: 11287
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.
Re: Dynamic image source [message #589084 is a reply to message #588673] Tue, 02 July 2013 02:13 Go to previous messageGo to next message
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 169 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 Go to previous messageGo to next message
MahdiAbuHassan
Messages: 7
Registered: May 2013
Location: Bahrain
Junior Member
Report output is attached above and report setting is attached below

[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 Go to previous message
Littlefoot
Messages: 19894
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.
Previous Topic: Multiple record printing on same line no in oracle report10g
Next Topic: SRW.ATTR must be declared
Goto Forum:
  


Current Time: Mon Dec 22 22:01:46 CST 2014

Total time taken to generate the page: 0.14484 seconds