Convert XML data as blob image [message #632394] |
Thu, 29 January 2015 15:38 |
wtolentino
Messages: 398 Registered: March 2005
|
Senior Member |
|
|
we have an apps that was receiving a data feed in xml. this xml file is being parsed and inserted to oracle table. one of those data in xml is a raw data if i understand the terminology correctly, which is converted into an image and stored in a blob column. the image in the blob is displyed in oracle report. there is an oracle java procedure which converts this raw data to an image and insert it in the blob column. the problem is most of the times it does not work.
we want to move out of that java piece of code and use oracle. is there a built-in package/procedure/function that will convert the raw data in image so we can store it as a blob?
for example this is the data in xml:
R0lGODlhhABmAMQAAAAAADAwMD8/P2BgYG9vb38AAH8/P39/f5CQkL8AAL+/v8DAwN/f3////wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAACH5BAAAAAAALAAAAACEAGYAAAX+YCOOZGmeaKqubOu+cCzPdG3feK7vfO//wKBwSCwaj8jkUaFAMJ0KpXQpAhwE02xRsUAAvgOtGKgANAWLA2LM3h3CikF03a 7bnA0CtgGw+2cICF0CDAgBf4gvC2UDZgMMiZErUQ1eC5KYKZR5mZ0mkCKgWQQLj6YMjw0DBwcEB0xyBw0MBLR5l4+ur1cElYEIDAddgawCBE67pLIDdJ4jTbK6qpCrrK8KBE0 iwlG1DbKsCAIIBIe7a2q7rOULrmm14LLOI5c
...
thanks,
warren
|
|
|
|
|
|