Problem solve
Get help with specific problems with your technologies, process and projects.
Oracle XML
Oracle XML capabilities in Oracle Database 11gR2, part 1
New Oracle XML capabilities in Oracle Database 11gR2 allow for easier reading and manipulation of XML documents, according to columnist Jeff McCormick. In part 1, McCormick introduces the reader to XML capabilities in Oracle Database and sets up a ... Continue Reading
Parsing, converting and loading image with XML
I have to parse an image from XML. The image is in base64 encoded form. I have to parse the image, convert it to binary and load it in a blob in an Oracle database. Continue Reading
Concatenating XML fragments
Using XMLElement and XMLForest I have created several XML "strings." In a final XMLElement select statement with XMLForest I want to concat the earlier strings within the output of the final statement. Can concat be used within XMLElement or ... Continue Reading
-
CLOB string too long
When you concatenate, Oracle treats a clob as a varchar2 and then, at over 4000 characters, the string becomes too long to handle. Do you have any ideas to get around this so that I can have larger HTML pages? Continue Reading
Using the XMLElement function
-