Gets an Oracle error message

Описание

string ora_error ([ resource $cursor_or_connection ] )

Returns the error message of the last executed statement on the specified cursor or connection.

Список параметров

cursor_or_connection: An Oracle cursor or connection identifier.

Возвращаемые значения

Returns an error message of the form XXX-NNNNN where XXX is where the error comes from and NNNNN identifies the error message.

Список изменений

Версия	Описание
5.1.0	The oracle extension is deprecated in favor of oci8.
3.0.4	Support for connection identifiers was added.

Примеры

On Unix versions of Oracle, you can find details about an error message like this:


$> oerr ora 00001

Результатом выполнения данного примера будет что-то подобное:



00001, 00000,
"unique constraint (%s.%s) violated" // *Cause: An update or insert
statement attempted to insert a duplicate key //         For Trusted
ORACLE configured in DBMS MAC mode, you may see //         this message
if a duplicate entry exists at a different level.  // *Action: Either
remove the unique restriction or do not insert the key

Примечания

When using oci8 as a replacement for the deprecated oracle extension, consider using:

oci_error()