Home » Developer & Programmer » Forms » forms to xml
forms to xml [message #183354] Thu, 20 July 2006 08:37 Go to next message
orafan2003
Messages: 122
Registered: February 2006
Senior Member
Hi,
I am entering some data into my form and this is getting saved to the database. Now how can I get this data in XML format?
Thank you.
Re: forms to xml [message #183458 is a reply to message #183354] Fri, 21 July 2006 01:15 Go to previous messageGo to next message
orafan2003
Messages: 122
Registered: February 2006
Senior Member
Hi,
The requirement is like this:
I have a forms for entering details about orders. Then after entering the details, I click on one button "SAVE" so that this data gets saved into a database table. At the same time it has to create a XML file with all this data. How can I achieve this task? This XML will be later on used to invoke BPEL and webservices.
I just got a rough idea that I should use some PLSQL code...but where and how to use it?
Can you guide me?
Re: forms to xml [message #184558 is a reply to message #183458] Thu, 27 July 2006 01:10 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
It sounds as though you need to use 'utl_file' to output a file from the database. Depending on where they want the file to go you may need to use 'web_util' to write to the client PC.

David
Re: forms to xml [message #193879 is a reply to message #183354] Tue, 19 September 2006 15:45 Go to previous message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
since you are saveing the data in the database, read up on using one of the many database packages that extrac xml from the database. You can save the data and then read it back as xml real easy with these guys. This should give you some idea.

SQL> select dbms_xmlgen.getxml('select * from dual') from dual;

DBMS_XMLGEN.GETXML('SELECT*FROMDUAL')
-----------------------------------------------------------------
<?xml version="1.0"?>
<ROWSET>
<ROW>
<DUMMY>X</DUMMY>
</ROW>
</ROWSET>


1 row selected.

Check the articles posted here too for some ideas.

Good luck, Kevin
Previous Topic: How to avoid service call to database when populating labels at runtime ?
Next Topic: Bar Code Reading
Goto Forum:
  


Current Time: Sat Dec 10 12:36:25 CST 2016

Total time taken to generate the page: 0.07287 seconds