Solved

How to read an HTML Document in an Oracle Package

Posted on 2014-09-29
5
199 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 77

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 77

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

Suggested Solutions

Title # Comments Views Activity
Adobe Connect eLearning pricing 2 17
Oracle dataguard 5 47
join actual table rows based on the column 25 22
making a message body variable from an oracle select statement 4 25
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
*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 …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

821 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