Hi All,

I’m having trouble with a hyperlink in my XML file.

Here is my complete scenario. The final output is a PDF document.

I’m converting a XML file into PDF document using Oracle BI Publisher reporting tool. I’m using a XSL-FO stylesheet to preserve the formatting features.

In this XML file I have a column,let’s say CLOB_COLUMN. In this CLOB_COLUMN I have the following

<CLOB_COLUMN>
<fo:block xmlns:fo="http://www.w3.org/1999/XSL/Format" xmlns:html="http://www.w3.org/1999/xhtml">
<fo:block font-family="Arial" font-size="10pt" white-space-collapse="false" text-align="justify" orphans="2" widows="2" language="en">
<fo:inline font-size="10pt"> The Todd Henderson controversy might inspire you to revisit your definition of what it means to be wealthy.</fo:inline>
</fo:block>
<fo:block font-family="Arial" font-size="10pt" white-space-collapse="false" language="en" white-space-treatment="preserve"/>-
<fo:block font-family="Arial" font-size="10pt" white-space-collapse="false" text-align="justify" orphans="2" widows="2" language="en">
<fo:inline font-size="10pt"> The deal, reached after AIG's board met with government officials on Wednesday, shows the insurer is making gradual progress in disentangling itself from the government, although the U.S. Treasury initially will take a larger stake the company in preparation for selling it down.</fo:inline>
</fo:block>
<fo:block font-family="Arial" font-size="10pt" white-space-collapse="false" language="en" white-space-treatment="preserve"/>-
<fo:block font-family="Arial" font-size="10pt" white-space-collapse="false" text-align="justify" orphans="2" widows="2" language="en">
<fo:inline font-size="10pt"> Stocks retreated Thursday as investors decided to lock in profits at the end of a historically strong month. Indexes rose sharply just after the market opened following news that unemployment claims dropped and manufacturing activity in the Chicago area rose.</fo:inline>
</fo:block>
<fo:block font-family="Arial" font-size="10pt" white-space-collapse="false" language="en" white-space-treatment="preserve"/>-
<fo:block font-family="Arial" font-size="10pt" orphans="2" widows="2" language="en">-
<fo:basic-link font-family="Arial" font-size="10pt" color="#0000ff" external-destination="url(S:\XXXXX)" text-decoration="underline">
<fo:inline font-family="Arial" font-size="10pt" color="#0000ff" text-decoration="underline">S:\XXXX</fo:inline>
</fo:basic-link>
</fo:block>
</fo:block>
</CLOB_COLUMN>

As you can see I have some notes and a hyperlink and it might contain images also. The problem is when a user clicks on the hyperlink present in the PDF document. The URL seems to add ///u01/oracle/product/10.1.3/dmidr3/j2ee/home/ before the actual path specified in the XML file and there by the user wasn’t able to open the document. Is there a way to trim or cut that extra path so that the URL is accessable?

Some more explaination of this issue is specified here
http://forums.oracle.com/forums/mess...592791#4592791

but I wasn’t able to solve this issue. Please, guide me in a right direction.