Solved

How to read an HTML Document in an Oracle Package

Posted on 2014-09-29
5
217 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

In a previous article published here at Experts Exchange, Signature Image with Transparent Background (http://www.experts-exchange.com/Web_Development/Document_Imaging/A_12380-Signature-Image-with-Transparent-Background.html), I explained how to cre…
The Adobe PDF proprietary file format is recognized as secure and formulated. But these PDF files are also prone to corruption and any external threat like virus attacks, improper storage can hit PDF file integrity.This type of damages can make cruc…
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.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

623 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