OraFAQ Forum: Forms » forms to xml

Home » Developer & Programmer » Forms » forms to xml

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

forms to xml [message #183354]

Thu, 20 July 2006 08:37

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.

Report message to a moderator

Re: forms to xml [message #183458 is a reply to message #183354]

Fri, 21 July 2006 01:15

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?

Report message to a moderator

Re: forms to xml [message #184558 is a reply to message #183458]

Thu, 27 July 2006 01:10

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: forms to xml [message #193879 is a reply to message #183354]

Tue, 19 September 2006 15:45

Kevin Meade
Messages: 2103
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

Report message to a moderator

Previous Topic:	How to avoid service call to database when populating labels at runtime ?
Next Topic:	Bar Code Reading

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 04:09:37 CST 2025