| Export Forms data to XML and Import XML data into Forms [message #380719] |
Tue, 13 January 2009 02:14  |
sammydude
Messages: 34
Registered: November 2007
|
Member |
|
|
Hi all,
I have a requirement where Oracle Forms data has to be exported in XML format.
The XML files will be opened in MS-Excel and edited.
After this the XML file has to be imported back into forms.
Is there a way to do this?
Pls help!
Regards,
Sam
|
|
|
|
| Re: Export Forms data to XML and Import XML data into Forms [message #380954 is a reply to message #380719] |
Wed, 14 January 2009 06:11  |
parag_narkhede
Messages: 110
Registered: January 2008
Location: Pune
|
Senior Member |
|
|
I think i had similar kind of requirement last year.
I have created one export button on form through which I will call one concurrent program in Oracle applications 11i which is of XML report. After this it will give you option to save this excel file.
Then I have created one UPLOAD FILE button which will upload this file into database using SQL*Loader. I have used shell scripts for this.
If you have similar kind of requirement, get back to me.
Are you using Oracle Applications 11i?
|
|
|
|
| Re: Export Forms data to XML and Import XML data into Forms [message #381197 is a reply to message #380954] |
Thu, 15 January 2009 11:45 |
sammydude
Messages: 34
Registered: November 2007
|
Member |
|
|
Hi Parag,
My requirement ends with exporting data to XML file. Thereafter the XML file should be imported back into Oracle Forms.
I can't use shell scripts for uploading, since we are on Windows.
I am allowed to use PL/SQL / Webutil.
This requirement is not for Oracle Apps but for an internal forms tool.
Pls let me know reg. steps if the export to XML involves PL/SQL.
Thanks,
Sam
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
