mwooldridge wrote:Always post HTML code using <tt>\
I have a table with html content that contains url's to apex pages similar to
<a href="f?p=115:300:???:PAGE:::P300_PAGE_NAME:test_page>test page</a> <a href="f?p=115:300:???:PAGE:::P300_PAGE_NAME:another_test_page>another test page</a>
</tt> tags to prevent it being rendered by the forum software.
Where ??? needs to be the session id.How do you retrieve and render the content?
I could use wwv_flow.do_substitutions to render the content and use &SESSION. in place of the question marks.
Did not like this option as my content is in a CLOB and didn't want to parse all the content if the links are never clicked, also the content could be very large.I don't like that option because it uses an undocumented, unsupported API call.
mwooldridge wrote:What's wrong with the the source procedure performing a simple replace on whatever placeholder is used in the links when the CLOB is retrieved?
The content is displayed in an html region with a source that is a plsql proocedure. The procedure simply loops over the CLOB in chunks and uses htp.p
... l_html := replace(l_html, '???', v('APP_SESSION')); ...
mwooldridge wrote:Why is this necessary? works on CLOBs<tt>replace</tt> works on CLOBs.
Since it is a clob and retrieved in chunks, it is possible the ??? could span a chunk and would not be found. I was hoping to find a way to insert the session when the link is clicked.
The replace solution would work if the size was < 32767 and could read the all the content into a plsql variable.