oci_error
(PHP 5)
oci_error -- Returns the last error found
Popis
array
oci_error ( [resource source] )
Returns the last error found.
Návratové hodnoty
If no error is found, oci_error()
returns FALSE. oci_error() returns the error as an
associative array. In this array, code
consists the oracle error code and message
the oracle error string.
Příklady
Příklad 1. Displaying the Oracle error message after a connection error
$conn = @oci_connect("scott", "tiger", "mydb"); if (!$conn) { $e = oci_error(); // For oci_connect errors pass no handle echo htmlentities($e['message']); }
|
|
Příklad 2. Displaying the Oracle error message after a parsing error
$stmt = @oci_parse($conn, "select ' from dual"); // note mismatched quote if (!$stmt) { $e = oci_error($conn); // For oci_parse errors pass the connection handle echo htmlentities($e['message']); }
|
|
Příklad 3. Displaying the Oracle error message and problematic statement
after an execution error
$r = oci_execute($stmt); if (!$r) { $e = oci_error($stmt); // For oci_execute errors pass the statementhandle echo htmlentities($e['message']); echo "<pre>"; echo htmlentities($e['sqltext']); printf("\n%".($e['offset']+1)."s", "^"); echo "</pre>"; }
|
|
Poznámky
Poznámka:
In PHP versions before 5.0.0 you must use ocierror() instead.
This name still can be used, it was left as alias of
oci_error() for downwards compatability.
This, however, is deprecated and not recommended.