<xsql:dml>

Executes a SQL DML statement or PL/SQL anonymous block.

XSQL Syntax

<xsql:dml>
  SQL DML or PL/SQL code
</xsql:dml>

Examples

The examples below execute a single DML statement, a single stored procedure, and combined statements.

A single DML statement:

<xsql:dml> INSERT INTO dept( deptno, dname ) VALUES ({@dept},'{@dname}');</xsql:dml>

A single stored procedure:

<xsql:dml>my_package.my_procedure({@dname});</xsql:dml>

An anonymous block to combine statements:

<xsql:dml>
  BEGIN
    INSERT INTO dept( deptno, dname ) VALUES ({@dept},'{@dname}');
    my_package.my_procedure({@dname});
  END;
</xsql:dml>

Description

The <xsql:dml> tag executes a SQL DML statement or PL/SQL anonymous block. Use the DML panel to enter the required SQL DML or PL/SQL code. This tag is typically used to include statements that would be executed or rolled back together.

The <xsql:dml> tag has no attributes.