OraFAQ Forum: Precompilers, OCI & OCCI

Home » Developer & Programmer » Precompilers, OCI & OCCI » Pro*C XML sample (9.2)

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

Pro*C XML sample [message #557425]

Tue, 12 June 2012 12:55

raghx
Messages: 27
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.

Report message to a moderator

Re: Pro*C XML sample [message #557431 is a reply to message #557425]

Tue, 12 June 2012 13:32

Michel Cadot
Messages: 54226
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

Report message to a moderator

Re: Pro*C XML sample [message #557801 is a reply to message #557431]

Fri, 15 June 2012 16:28

raghx
Messages: 27
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

Report message to a moderator

Re: Pro*C XML sample [message #557827 is a reply to message #557801]

Sat, 16 June 2012 00:51

Michel Cadot
Messages: 54226
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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 24 04:52:07 CDT 2013

Total time taken to generate the page: 0.10878 seconds