Built-in Action Handler

Table 19-2 lists the XSQL Pages built-in Action Elements.

Table 19-5 Action Handler Elements 

Action Handler Element	Description
<xsql:query>	Execute an arbitrary SQL statement and include its result set in canonical XML format.
<xsql:dml>	Execute a SQL DML statement or PL/SQL anonymous block.
<xsql:set-stylesheet-param>	Set the value of a top-level XSLT stylesheet parameter. Value of the parameter can be set by supplying the optional "value" attribute, or by including a SQL statement as the element content.
<xsql:insert-request>	Insert the (optionally transformed) XML document that has been posted in the request into adatabase table or view. If HTML Form has been posted, then posted XML document is materialized from HTTP request parameters, cookies, and session variables.
<xsql:include-xml>	Include arbitrary XML resources at any point in your page by relative or absolute URL.
<xsql:include-request-params>	Include key information like HTTP Parameters, Session Variable values and Cookies into your XSQL Page for addressing them in your stylesheet.
<xsql:include-xsql>	Include the results of one XSQL Page at any point inside another.
<xsql:include-owa>	Include the results of executing a stored procedure that makes use of the Oracle Web Agent (OWA) packages inside the database to generate XML.
<xsql:action>	Invoke a user-defined action handler, implemented in Java, for executing custom logic and including custom XML information into your XSQL Page.
<xsql:ref-cursor-function>	Includes the canonical XML representation of the result set of a cursor returned by a PL/SQL stored function.
<xsql:set-page-param>	Set a page-level (local) parameter that can be referred to in subsequent SQL statements in the page. The value can be set using a static value, the value of another parameter, or the results of a SQL statement.
<xsql:include-param>	Include a parameter and its value as an element in your XSQL page.
<xsql:set-session-param>	Set an HTTP-Session level parameter. The value can be set using a static value, the value of another parameter, or the results of a SQL statement.
<xsql:set-cookie>	Set an HTTP Cookie. The value can be set using a static value, the value of another parameter, or the results of a SQL statement.
<xsql:insert-param>	Inserts the value of a single parameter containing XML. Can optionally supply a transform to get it in canonical format.

See Also: The latest XSQL Servlet Release Notes at the OTN site, at http://technet.oracle.com/tech/xml, under XDK for Java > XSQL Servlet. The Release Notes document what additional actions you need to take if you are: Using the <xsql:include-owa> action element Running XSQL Servlet form inside a corporate firewall. Uncomment the http line... Using <xsql:include-request-params> element. Use specific format... Using <xsql:include-xml> element. Results must be well-formed. Using <xsql:insert-request> action element. First determine the canonical format you need for the inserts...