Automatic Oracle interaction with XML.

[shinobyghost]

Hello, I'm new to this forum, I'm new to programming at DB Oracle. I would like to collaborate to solve my problem ...

I am trying to develop an import and export system through XML.
to import the XML file:
- I created an "IMPORT" folder, will have a job that will check the folder to see if there is an XML, if it checks the contents of the XML and If there is no table it creates a new one if it exists it does the insert or update. After the end of this process it moves the XML file to "import_ok" folder.
- I created the "Export" folder, where the XML files are going to be exported by FTP.

My question is if I will have to create a job for each XML file, or do you have any resource in Oracle that he can identify that the * .xml file exists?
What is the best method so that I can load the XML information to the table?
Is there any command that Oracle can move the folder file in case the XML of the "import" folder for "import_ok" folder?

Thank you very much for everyone's attention!

[madmax]

Face of a look at this link
http://mportes.blogspot.com.br/2009/05/ ... -java.html

with him you will do what you want "resource in Oracle that he can identify that the file exists * .xml "

I hope I have helped.

Douglas - Madmax

[shinobyghost]

Face to take a look at this link
http://mportes.blogspot.com.br/2009/05/ ... -java.html

With him you will do what you want "resource in Oracle that he I can identify that the * .xml file exists "

I hope I have helped.

Douglas - Madmax

Thank you Douglas!

[madmax]

It was nothing anything put toe.

ABS.

[shinobyghost]

I have another question now.
I have to create a procedure, where I can read a single XML file [/ u], but within that XML has information to more than one table [/ u], I want to make inserts The corresponding tables, all this using utl_file .

[carlynhos77]

Hello, good night ....

I have the same problem with XML, I need to read a file with payroll information to mount counter-check, in this has several data, which need to be Saved in distinct tables ... Shinobyghost, could you solve it there ?? If you can share, thank you very much