A script-enabled browser is required for this page to function properly.

SRW.SET_LINKTAG built-in procedure

This procedure specifies an object's identifier and can be used as the destination in Web links.

Syntax

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. 

Restrictions

SRW.SET_LINKTAG should only be set in a format trigger.

GUI access

You can also define this attribute using the Reports Builder user interface:

Property Inspector

Set the Hyperlink Destination property.

Examples

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;

See also

Creating a hyperlink using PL/SQL

About the Reports Builder built-in package (SRW)

SRW built-in package