My Oracle Support Banner

LINKS NOT CREATED IN REPORTS FROM SQL QUERY (Doc ID 139840.1)

Last updated on APRIL 01, 2025

Applies to:

Portal - Version 3.0 to 3.0.9.8.5 [Release Portal 3.0 to 9iAS]
Information in this document applies to any platform.

Symptoms

Creating a Report in Portal and the Report is based on a SQL query. The SQL query has an link to a column.

For example, the SQL query looks something like this:

select '<a href="http://www.oracle.com">Oracle Home Page</a>' ename
from <SCHEMA>.EMP

When running the Report, you do not see the link, but the html text of the link as below:

<COLUMN>
--------------
<a href="http://www.oracle.com">Oracle Home Page</a>

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.