To add a hyperlink to your report using PL/SQL instead of the Property Inspector:
In the Object Navigator, expand the Paper Layout node, then expand the node that contains the object that will be the source of the Web link. Note: If you are defining a template, you can select objects in the Margin. Objects in the body are unknown until the template is applied to a report.
Double-click
(the PL/SQL icon) next to the object that will be the source of the Web
link.
In the PL/SQL Editor, include SRW.SET_HYPERLINK to define the PL/SQL for the format trigger.
To apply additional HTML attributes to the hyperlink, use SRW.SET_HYPERLINK_ATTRS.
Next step
Creating a hyperlink destination using PL/SQL
Creating a hyperlink destination using the Property Inspector
Creating a hyperlink using the Property Inspector
About Web links for HTML output
About Web links for PDF output
Copyright © 1984, 2005, Oracle. All rights reserved.