Store the Data from Oracle to XML output file

nandela.sudheer · Post by **nandela.sudheer** » Mon May 17, 2010 12:22 am

i want to store the data from Oracle to XML output file.
i am using Oracle stage-------->XML Output file. at tht time i got one below error message .

error message:
XML_Output_0: Derivation rule "<none>" is invalid. Message = "Unexpected token!
expression = '<none>'
Remaining tokens: ('<' 'none' '>')"

chulett · Post by **chulett** » Mon May 17, 2010 12:26 am

Stick a transformer between those two stages and then let us know how much XML experience you have. Do you have an xsd for the target file?

nandela.sudheer · Post by **nandela.sudheer** » Mon May 17, 2010 12:47 am

i used transformer stage in between those two stages,again i got the same wornings and file also not created in the server,i don't have experience in the XML and i don't have the XSD traget file

eostic · Post by **eostic** » Mon May 17, 2010 3:22 am

You need to spend some time researching xml and this forum. Also read the documentation on the xml stages.

You will need to know what the xml target you want "looks like" and then import that metadata (or type it in, once you learn how that works).

Find also the xml best practices (tons of threads in this forum about it and where to get it)...it's a bit advanced for what you are doing right now, but will become a valuable tool as you move forward.

Ernie

chulett · Post by **chulett** » Mon May 17, 2010 6:18 am

Do you work with someone who can help you with the XML specific bits? What have you been given that defines what the output XML needs to look like? Anything?

ps. The transformer wasn't meant to fix anything, it is just a Best Practice to use an active stage between two passive ones, not to mention the fact that it gives you a chance to do something to the data passing through if you need to.

nandela.sudheer · Post by **nandela.sudheer** » Wed May 19, 2010 12:48 am

job completed successfully but at that time file was not created in the server

chulett · Post by **chulett** » Wed May 19, 2010 1:08 am

And now, are you getting what you need? Care to share your "workaround"?

nandela.sudheer · Post by **nandela.sudheer** » Wed May 19, 2010 2:06 am

i am loading the from Oracle to XML file,i am using Oracle stage ----->XML output file.job was finished successfully,file was not creatted in the Server.

chulett · Post by **chulett** » Wed May 19, 2010 6:32 am

So... did you read Ernie's post and follow any of his advice? There's a lot to learn to do XML successfully and it's not something we can teach anyone in a post or two here. You need to put some effort in on your part and then we can help when you have specific questions or there are problems with the fiddley bits.

If the job runs but there's no output, that means issues with your XPath Expressions. That's what having an xsd would get you - the proper metadata that the stage needs to produce the proper output.