Solved

How to read an HTML Document in an Oracle Package

Posted on 2014-09-29
5
192 Views
Last Modified: 2015-06-23
The following is a business scenario we have:
1) A User fills out a Time Sheet on a PDF Document.
2) The PDF Document is then sent via email to our Exchange Server.
3) Once the document is received at our Exchange Server, PDF LiveCycle generates an HTML version of the PDF.

My question is this:
I want to create an Oracle Package that can read the HTML Document from a Shared Folder.  I've created many Oracle Packages but I have never created a Package that can read the Tags of an HTML Document.

How can I do this?  Sample code would be greatly appreciated.
0
Comment
Question by:BISCO3
  • 2
5 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 40350374
Is the HTML XHTML compliant?

If it is basically an XML document, you can use many ways to parse the XML.

You can pass the XML into the procedure as a CLOB parameter or if it is on the database server, read it directly from the file system.

Then it is a matter of parsing the XML.

I would probably start with XMLTABLE:
http://docs.oracle.com/cd/E11882_01/server.112/e41084/functions253.htm#SQLRF06232

If the XML is really complex, you might be better off using the DOM.

The more information you can provide us, the more exact our comments.
0
 

Author Comment

by:BISCO3
ID: 40650195
Solution Accepted.
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40650274
Sorry but just posting "Solution Accepted." doesn't do anything.

What are you trying to do?
0
 
LVL 22

Expert Comment

by:Steve Wales
ID: 40845979
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

*Adobe Acrobat 9 was used for this article. Particular steps may vary depending on software versions. 1. Create a framework of your form in Word, leaving space where you’d ultimately like the Adobe fields to appear.  (Note: I use the blank lines …
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question