SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to parse HTML via PL/SQL

863006Oct 13 2011 — edited Oct 13 2011

Hi all,
please can anybody tell what is my option to parse HTML via PL/SQL API? In my case i have to export data via PRIMAVERA(i think is not that important from where export) into Oracle E-Business Suite and show the result in RTF template. But when get the data from PRIMAVERA it shows HTML tags concatenated with the result expected.

For example:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> test description

I created a function which replaces HTML tags set in advance but i can't specify all the HTML tags in a function so my question is there any usefull PL/SQL API to achieve this?

version:

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
PL/SQL Release 11.1.0.7.0 - Production
"CORE	11.1.0.7.0	Production"
TNS for Linux: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production

Thanks in advance,
Bahchevanov.

This post has been answered by odie_63 on Oct 13 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 10 2011

Added on Oct 13 2011

11 comments

5,219 views