oci_error

Description

For most errors, the parameter is the most appropriate resource handle. For connection errors with oci_connect(), oci_new_connect() or oci_pconnect(), do not pass a parameter. 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.

Beispiel 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']); }

Beispiel 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']); }

Beispiel 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>"; }