OraFAQ Forum: SQL & PL/SQL » BLOB msg print in xml format

Home » SQL & PL/SQL » SQL & PL/SQL » BLOB msg print in xml format (Oracle 12c)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

BLOB msg print in xml format [message #680709]

Tue, 02 June 2020 09:29

bkbora
Messages: 21
Registered: April 2020

Junior Member

Hi,
I have a requirement where I will pass the emp id and emp pan then it will provide the result. In which one of the column called (c

) having BLOB data which I want to print in xml format. Can anyone help me how to do that. Any shell script or any automation will be much appriciated

Report message to a moderator

Re: BLOB msg print in xml format [message #680710 is a reply to message #680709]

Tue, 02 June 2020 09:30

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

Report message to a moderator

Re: BLOB msg print in xml format [message #680713 is a reply to message #680709]

Tue, 02 June 2020 11:19

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Only YOU know how the data are stored in the BLOB, no one can help you with what you posted.

With any SQL or PL/SQL question, please, Post a working Test case: create table (including all constraints) and insert statements along with the result you want with these data then we will be able work with your table and data. Explain with words and sentences the rules that lead to this result.

Report message to a moderator