OraFAQ Forum: Forms » how to generate XML data of SQL query through forms 10g

Home » Developer & Programmer » Forms » how to generate XML data of SQL query through forms 10g (Oracle 11g, windows XP SP3)

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

how to generate XML data of SQL query through forms 10g [message #590512]

Fri, 19 July 2013 01:12

5vinod
Messages: 12
Registered: June 2012
Location: chennai

Junior Member

Hi all,
I have got requirement to generate a .XML format of a select query in a particular folder in server.
The XML coding of a select query i got through DBMS_XMLGEN.getXML package.

SELECT DBMS_XMLGEN.getXML('SELECT * FROM EMPL_NEW') FROM dual

but through forms i am unable to create it!! and the result output should be saved as .xml in a particular folder in server...

anybody please help...

thanks in advance
Vinoth

Report message to a moderator

Re: how to generate XML data of SQL query through forms 10g [message #590542 is a reply to message #590512]

Fri, 19 July 2013 03:18

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

If it doesn't work directly from a form, perhaps you could try to put that SELECT statement into a SQL script, and then call the script from a form (using HOST built-in).

Report message to a moderator