Home » Developer & Programmer » Precompilers, OCI & OCCI » Pro*C XML sample (9.2)
Pro*C XML sample [message #557425] Tue, 12 June 2012 12:55 Go to next message
raghx
Messages: 28
Registered: March 2006
Location: Bangalore
Junior Member
Hi All,
I'm require to read a JMS/XML message from Websphere MQ using Pro*C. Hence would like to have any sample program to read XML data using Pro*C. With XSD should be fine.

Please help.

Re: Pro*C XML sample [message #557431 is a reply to message #557425] Tue, 12 June 2012 13:32 Go to previous messageGo to next message
Michel Cadot
Messages: 57613
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do it in the same way than in C.
How is this related to Oracle?

Regards
Michel
Re: Pro*C XML sample [message #557801 is a reply to message #557431] Fri, 15 June 2012 16:28 Go to previous messageGo to next message
raghx
Messages: 28
Registered: March 2006
Location: Bangalore
Junior Member
Have to read the MQ message, which will have the xml data/string, then process it in pl/sql and store it in the table. But to access the MQ we have Pro*C so wondering how I can use Pro*C for XML
Re: Pro*C XML sample [message #557827 is a reply to message #557801] Sat, 16 June 2012 00:51 Go to previous message
Michel Cadot
Messages: 57613
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
then process it in pl/sql and store it in the table


There are many examples in this forum how to convert xml data into table columns with SQL or PL/SQL.

Regards
Michel
Previous Topic: Pro*C -- Linker Error: Undefined symbol _sqlcxt in module
Next Topic: Pro*C using OCI (21700: object does not exist or is marked for delete)
Goto Forum:
  


Current Time: Sun Apr 20 18:31:47 CDT 2014

Total time taken to generate the page: 0.05392 seconds