Forum und email

ora_error

(PHP 4, PHP 5 <= 5.0.5)

ora_error — 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.

Return值

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: