SRW.SET_LINKTAG
built-in procedureThis procedure specifies an object's identifier and can be used as the destination in Web links.
SRW.SET_LINKTAG('linktag');
Parameter |
Description |
linktag |
A valid, unique name that only makes use of the 26 upper or lower case US ASCII letters, numbers, or underscore characters. Other special characters will automatically be converted to underscore characters. |
SRW.SET_LINKTAG
should only
be set in a format trigger.
You can also define this attribute using the Reports Builder user interface:
Property Inspector |
Set the Hyperlink Destination property. |
Example 1
The format trigger below assigns an identifier (mytarget) to the boilerplate object B_500. This means that the object can now be the destination of a Web link.
function B_500FormatTrigger return boolean is
begin
SRW.SET_LINKTAG('mytarget');
return (TRUE);
end;
Example 2: Dynamic SRW.SET_LINKTAG
example
The format trigger below assigns an identifier to the field F_Dept by concatenating some static text (dept_details_) with the value of the source column (DEPTNO). This function ensures that a unique identifier is assigned to each instance of F_Dept.
function F_DeptFormatTrigger return boolean is
begin
SRW.SET_LINKTAG('dept_details_' ||
LTRIM(TO_CHAR(:deptno)));
return (TRUE);
end;
Creating a hyperlink using PL/SQL
About the
Reports Builder built-in package (SRW
)
Copyright © 1984, 2005, Oracle. All rights reserved.