I am trying to load XML file to Oracle. The job finishes without any errors but the file is not loading (it seems as there is no data at XML file - the file is empty). I know for sure that there is data at the file!
I am using the following stages:
Folder->XML Input->Transformer->Oracle OCI.
Will be glad to receive some advice , thanks.
XML file loading
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 68
- Joined: Sat Feb 05, 2005 4:59 am
- Location: India
-
- Premium Member
- Posts: 68
- Joined: Sat Feb 05, 2005 4:59 am
- Location: India
-
- Charter Member
- Posts: 23
- Joined: Mon Dec 29, 2003 7:38 am
- Location: Finland, Northern Europe
Check that you are NLS-enabled and the folder stage is set to read UTF-8 if the xml file is defined to be utf-8 encoded.
Other way to do it is to set the FileName as input column for the xml stage (In folder stage remember to set the Fully qualified -property to Yes). Then in the xml stage set the input column to include the file path (Input/XML Source-page). This way xml stage does the parsing directly against the file not against the data from folder stage and encoding is handled by xml stage.
Good luck,
Janne
Other way to do it is to set the FileName as input column for the xml stage (In folder stage remember to set the Fully qualified -property to Yes). Then in the xml stage set the input column to include the file path (Input/XML Source-page). This way xml stage does the parsing directly against the file not against the data from folder stage and encoding is handled by xml stage.
Good luck,
Janne