Developer Transformation Guide

10.4.0
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5
- 10.4.1
- 10.2.2 HotFix 1
- 10.2.2 Service Pack 1
- 10.2.2
- 10.2.1

Back Next

SQLError Port

The SQLError port returns SQL errors from the database from stored procedures or SQL queries.

The following figure shows the SQLError port in a reusable SQL transformation:

The Overview view shows the name, description, and ports of the SQL transformation. The Ports section of the Overview view shows the SQLError output port.

When the SQL query contains syntax errors, the SQLError port contains the error text from the database. For example, the following SQL query generates a row error from an Oracle database:

SELECT Product_ID FROM Employees

The Employees table does not contain Product_ID. The Data Integration Service generates one row. The SQLError port contains the error text in one line:

ORA-0094: “Product_ID”: invalid identifier Database driver error... Function Name: Execute SQL Stmt: SELECT Product_ID from Employees Oracle Fatal Error

You can configure multiple query statements in the SQL query or you can call multiple stored procedures. When you configure the SQL transformation to continue on SQL error, the SQL transformation might return rows for one query statement, but return database errors for another query statement. The SQL transformation returns any database error in a separate row.

Rename Saved Search

Table of Contents

Developer Transformation Guide

Developer Transformation Guide

SQLError Port

SQLError Port