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.
As of PHP 4.3: offset and sqltext will
also be included in the return array to indicate the location
of the error and the original SQL text which caused it.
Example 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']); }
Example 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']); }
Example 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>"; }
Note:
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.
Php oci error Function syntax tag
oci error php code on this is provided for your study purpose, it will guide you to know how create and design a website using php. use it to practice and train your self online
Php oci error syntax tutorial
php tutorial guide and code design are for easy learning and programming. The code practice section provided at the top is for practising of this syntax. Use the code section up to practice your php programming online. Learning php is very easy, all you need is to use the examples on this site and practice them to perfect your skills.