Home » SQL & PL/SQL » SQL & PL/SQL » BLOB msg print in xml format (Oracle 12c)
BLOB msg print in xml format [message #680709] Tue, 02 June 2020 09:29 Go to next message
bkbora
Messages: 15
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
Re: BLOB msg print in xml format [message #680710 is a reply to message #680709] Tue, 02 June 2020 09:30 Go to previous messageGo to next message
BlackSwan
Messages: 26733
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
Re: BLOB msg print in xml format [message #680713 is a reply to message #680709] Tue, 02 June 2020 11:19 Go to previous messageGo to next message
Michel Cadot
Messages: 67369
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: BLOB msg print in xml format [message #680718 is a reply to message #680713] Wed, 03 June 2020 01:03 Go to previous messageGo to next message
bkbora
Messages: 15
Registered: April 2020
Junior Member
No, the record is being inserted by the users and when they need BLOB contains we need to provide them by using the cutomer pan number.
Re: BLOB msg print in xml format [message #680719 is a reply to message #680718] Wed, 03 June 2020 01:26 Go to previous message
Michel Cadot
Messages: 67369
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What "no"?

Previous Topic: Split Comma seperated Value
Next Topic: Adding [CDATA[ element in an XML
Goto Forum:
  


Current Time: Fri Sep 25 23:27:21 CDT 2020