Home » Developer & Programmer » Forms » Export Forms data to XML and Import XML data into Forms (Oracle Forms 10g R2)
Export Forms data to XML and Import XML data into Forms [message #380719] Tue, 13 January 2009 02:14 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: Microsoft Spell Checker from Forms10g
Next Topic: TNS problem & TNS admin method (merged)
Goto Forum:
  


Current Time: Sun Dec 04 04:25:40 CST 2016

Total time taken to generate the page: 0.07308 seconds