sql:execute

Allows arbitrary SQL statements to be executed. No result is returned.

Attributes

connection

expression

The database connection. The value is an XPath expression, which must evaluate to a database connection object as returned by sql:connect.

statement

{ expression }

The SQL statement to be executed. The statements COMMIT WORK and ROLLBACK WORK (spelt exactly like that) are recognized specially, and cause calls on the JDBC connection.commit() and connection.rollback() methods respectively.

Saxon availability

Requires Saxon-PE or Saxon-EE. Available for Java only.