Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re: Handling BLOB data in ORACLE using perl script

by sundialsvc4 (Abbot)
on Sep 23, 2015 at 14:08 UTC ( [id://1142810]=note: print w/replies, xml ) Need Help??


in reply to Handling BLOB data in ORACLE using perl script

Start by using Data::Dumper to print what the $SERVICE_SPECIFIC_DATA_V variable actually contains.   You want to know, first of all, if this is, in fact, the XML data that you seek.   (A bit odd that it is an array, but let’s first find out what’s in it.   If it turns out to be XML, you’re in gravy.)

When you say, “invoke the BLOB as XML,” I really can’t anticipate what you mean by the word, “invoke.”   Nor, when you say “print it on my screen,” exactly what you have in mind.   Please clarify ...

XSLT is a standard technique for extracting data from XML and formatting it ... without programming.   XML::LibXML is a full-featured Perl package which uses an industry-standard library to do “everything XML.”   (There’s a very good chance that the library which it uses, libxml2, is the same one that was used to prepare the document you now have.)   Note that there are tools, commercial and otherwise, which can handle the entire task of getting XML from a database or other repository and formatting it to your taste.   (Online documentation, and all of the O’Reily books ... the ones with animals on the cover ... is prepared in just that way.)

The same library provides an excellent way for retrieving data from an XML document:   XPath expressions.   (This is a key technology in XSLT, too.)   You do not have to write a Perl program whose logic follows that of the XML document structure, in order to efficiently retrieve anything-you-want from that document.

(Now, if the XML document is so damned humongous that you can’t process it all at one time, there are other Perl packages that are specifically designed for that edge-case.   But I doubt that this is the issue here.)

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1142810]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others wandering the Monastery: (4)
As of 2024-04-25 16:01 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found