Consider the following classic employees table:
SQL> SELECT employee_id,
2 manager_id,
3 first_name,
4 salary,
5 hire_date
6 FROM employees;
EMPLOYEE_ID MANAGER_ID FIRST_NAME SALARY HIRE_DATE
———– […]
In this post I will show an example of how you can transform a query result into an XML document. I will also show how you can write a query that produces nested or multi-leveled XML document using cursor expressions.
A while ago Robert and Pete blogged about Oracle’s UTL_HTTP package. Robert gave an example of how to use this package to request a web page from the Internet into Oracle and Pete mentioned that you could do the opposite, i.e. post data from Oracle to the Internet. Recently I had a requirement to do […]
If you ever wondered what the purpose and location of the ColdFusion XML configuration files are, you have to read this ColdFusion TechNote. It describes the J2EE-standard XML files used by ColdFusion MX, the ColdFusion MX-specific XML server configuration files, and the XML files used to store ColdFusion MX Administrator settings. Very informative and useful.
First, let’s see how you can post XML over HTTP to another page. This is very simple in ColdFusion:
<cfhttp url=”url_to_post_to” method=”post”>
<cfhttpparam
type=”XML”
name=”XmlDoc”
value=”#your_xml#”>
</cfhttp>
Now, suppose you are posting […]