|
|
|
|
Bookmark this on Delicious
Share on Facebook
 Slashdot It!
Digg  oci_error
Returns the last error found
(PHP 5, PECL oci8:1.1-1.2.4)
Example 1639. Displaying the Oracle error message after a connection error$conn = @oci_connect("scott", "tiger", "mydb");Example 1640. Displaying the Oracle error message after a parsing error$stmt = @oci_parse($conn, "select ' from dual"); // note mismatched quoteExample 1641. Displaying the Oracle error message and problematic statement after an execution error$r = oci_execute($stmt);
Examples ( Source code ) » oci_error
Related Examples ( Source code ) » oci_error Examples ( Source code ) » Handling OCI8 Errors Examples ( Source code ) » PL/SQL Errors in PHP Code Examples / Notes » oci_errorbjanetzki
The second example (Displaying the Oracle error message after a parsing error) is wrong. This example works for me: $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']); } |
Change Language
oci_bind_array_by_name oci_bind_by_name oci_cancel oci_close OCI-Collection->append OCI-Collection->assign OCI-Collection->assignElem OCI-Collection->free OCI-Collection->getElem OCI-Collection->max OCI-Collection->size OCI-Collection->trim oci_commit oci_connect oci_define_by_name oci_error oci_execute oci_fetch_all oci_fetch_array oci_fetch_assoc oci_fetch_object oci_fetch_row oci_fetch oci_field_is_null oci_field_name oci_field_precision oci_field_scale oci_field_size oci_field_type_raw oci_field_type oci_free_statement oci_internal_debug OCI-Lob->append OCI-Lob->close oci_lob_copy OCI-Lob->eof OCI-Lob->erase OCI-Lob->export OCI-Lob->flush OCI-Lob->free OCI-Lob->getBuffering OCI-Lob->import oci_lob_is_equal OCI-Lob->load OCI-Lob->read OCI-Lob->rewind OCI-Lob->save OCI-Lob->saveFile OCI-Lob->seek OCI-Lob->setBuffering OCI-Lob->size OCI-Lob->tell OCI-Lob->truncate OCI-Lob->write OCI-Lob->writeTemporary OCI-Lob->writeToFile oci_new_collection oci_new_connect oci_new_cursor oci_new_descriptor oci_num_fields oci_num_rows oci_parse oci_password_change oci_pconnect oci_result oci_rollback oci_server_version oci_set_prefetch oci_statement_type ocibindbyname ocicancel ocicloselob ocicollappend ocicollassign ocicollassignelem ocicollgetelem ocicollmax ocicollsize ocicolltrim ocicolumnisnull ocicolumnname ocicolumnprecision ocicolumnscale ocicolumnsize ocicolumntype ocicolumntyperaw ocicommit ocidefinebyname ocierror ociexecute ocifetch ocifetchinto ocifetchstatement ocifreecollection ocifreecursor ocifreedesc ocifreestatement ociinternaldebug ociloadlob ocilogoff ocilogon ocinewcollection ocinewcursor ocinewdescriptor ocinlogon ocinumcols ociparse ociplogon ociresult ocirollback ocirowcount ocisavelob ocisavelobfile ociserverversion ocisetprefetch ocistatementtype ociwritelobtofile ociwritetemporarylob |
