---
name: "tdbc_mapSqlState"
section: "3tcl"
platform: "linux"
package: "tcl8.6-tdbc"
version: "1.1.10-2"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/tdbc_mapSqlState"
---

# tdbc\_mapSqlState(3tcl)

Map SQLSTATE to error class

```

```

## NAME

tdbc::mapSqlState - Map SQLSTATE to error class

## SYNOPSIS

```
package require tdbc 1.0
tdbc::mapSqlState sqlstate
```

```

```

## DESCRIPTION

The **tdbc::mapSqlState** command accepts a string that is expected to be a five-character 'SQL state' as returned from a SQL database when an error occurs. It examines the first two characters of the string, and returns an error class as a human- and machine-readable name (for example, **FEATURE\_NOT\_SUPPORTED**, **DATA\_EXCEPTION** or **INVALID\_CURSOR\_STATE**).

The TDBC specification requires database drivers to return a description of an error in the error code when an error occurs. The description is a string that has at least four elements: "**TDBC** *errorClass* *sqlstate* *driverName* *details...*". The **tdbc::mapSqlState** command gives a convenient way for a TDBC driver to generate the *errorClass* element given the SQL state returned from a database.

## SEE ALSO

[tdbc(3tcl)](/tdbc/3tcl.md), tdbc::tokenize, tdbc::connection(3tcl), tdbc::statement(3tcl), tdbc::resultset(3tcl)

## KEYWORDS

TDBC, SQL, database, state

## COPYRIGHT

Copyright (c) 2009 by Kevin B. Kenny.