db2_conn_errormsg(3) [php man page]

DB2_CONN_ERRORMSG(3)							 1						      DB2_CONN_ERRORMSG(3)

db2_conn_errormsg - Returns the last connection error message and SQLCODE value

SYNOPSIS

       string db2_conn_errormsg ([resource  $connection])

DESCRIPTION

       db2_conn_errormsg(3)  returns  an  error  message and SQLCODE value representing the reason the last database connection attempt failed. As
       db2_connect(3) returns FALSE in the event of a failed connection attempt, do not pass any parameters to	db2_conn_errormsg(3)  to  retrieve
       the associated error message and SQLCODE value.

	If,  however,  the connection was successful but becomes invalid over time, you can pass the $connection parameter to retrieve the associ-
       ated error message and SQLCODE value for a specific connection.

PARAMETERS

	      o $connection
		- A connection resource associated with a connection that initially succeeded, but which over time became invalid.

RETURN VALUES

	Returns a string containing the error message and SQLCODE value resulting from a failed connection attempt. If there is no  error  associ-
       ated with the last connection attempt, db2_conn_errormsg(3) returns an empty string.

EXAMPLES

       Example #1

	      Retrieving the error message returned by a failed connection attempt

	       The  following  example demonstrates how to return an error message and SQLCODE value after deliberately passing invalid parameters
	      to db2_connect(3).

	      <?php
	      $conn = db2_connect('badname', 'baduser', 'badpassword');
	      if (!$conn) {
		  print db2_conn_errormsg();
	      }
	      ?>

	      The above example will output:

	      [IBM][CLI Driver] SQL1013N  The database alias name
	      or database name "BADNAME" could not be found.  SQLSTATE=42705
	       SQLCODE=-1013

SEE ALSO

       db2_conn_error(3), db2_connect(3), db2_stmt_error(3), db2_stmt_errormsg(3).

PHP Documentation Group 												      DB2_CONN_ERRORMSG(3)

OCI_ERROR(3)															      OCI_ERROR(3)

oci_error - Returns the last error found

SYNOPSIS

       array oci_error ([resource  $resource])

DESCRIPTION

	Returns the last error found.

	The function should be called immediately after an error occurs. Errors are cleared by a successful statement.

PARAMETERS

	      o $resource
		-  For	most  errors,  $resource  is  the resource handle that was passed to the failing function call. For connection errors with
		oci_connect(3), oci_new_connect(3) or oci_pconnect(3) do not pass $resource.

RETURN VALUES

	If no error is found, oci_error(3) returns FALSE. Otherwise, oci_error(3) returns the error information as an associative array.

       oci_error(3) Array Description

       +----------+--------------------------------------+---+
       |Array key |					 |   |
       |	  |					 |   |
       |	  |		    Type		 |   |
       |	  |					 |   |
       |	  |		Description		 |   |
       |	  |					 |   |
       +----------+--------------------------------------+---+
       |	  |					 |   |
       |  code	  |					 |   |
       |	  |					 |   |
       |	  |					 |   |
       |	  |		  integer		 |   |
       |	  |					 |   |
       |	  |	  The Oracle error number.	 |   |
       |	  |					 |   |
       |	  |					 |   |
       | message  |					 |   |
       |	  |					 |   |
       |	  |					 |   |
       |	  |		   string		 |   |
       |	  |					 |   |
       |	  |	   The Oracle error text.	 |   |
       |	  |					 |   |
       |	  |					 |   |
       | offset   |					 |   |
       |	  |					 |   |
       |	  |					 |   |
       |	  |		  integer		 |   |
       |	  |					 |   |
       |	  |  The byte position of  an  error  in |   |
       |	  | the  SQL  statement. If there was no |   |
       |	  | statement, this is 0		 |   |
       |	  |					 |   |
       |	  |					 |   |
       | sqltext  |					 |   |
       |	  |					 |   |
       |	  |					 |   |
       |	  |		   string		 |   |
       |	  |					 |   |
       |	  |  The SQL statement	text.  If  there |   |
       |	  | was  no  statement, this is an empty |   |
       |	  | string.				 |   |
       |	  |					 |   |
       +----------+--------------------------------------+---+
EXAMPLES

       Example #1

	      Displaying the Oracle error message after a connection error

	      <?php
	      $conn = oci_connect("hr", "welcome", "localhost/XE");
	      if (!$conn) {
		  $e = oci_error();   // For oci_connect errors do not pass a handle
		  trigger_error(htmlentities($e['message']), E_USER_ERROR);
	      }
	      ?>

       Example #2

	      Displaying the Oracle error message after a parsing error

	      <?php
	      $stid = oci_parse($conn, "select ' from dual");  // note mismatched quote
	      if (!$stid) {
		  $e = oci_error($conn);  // For oci_parse errors pass the connection handle
		  trigger_error(htmlentities($e['message']), E_USER_ERROR);
	      }
	      ?>

       Example #3

	      Displaying the Oracle error message, the problematic statement, and the position of the problem of an execution error

	      <?php
	      $stid = oci_parse($conn, "select does_not_exist from dual");
	      $r = oci_execute($stid);
	      if (!$r) {
		  $e = oci_error($stid);  // For oci_execute errors pass the statement handle
		  print htmlentities($e['message']);
		  print "
<pre>
";
		  print htmlentities($e['sqltext']);
		  printf("
%".($e['offset']+1)."s", "^");
		  print  "
</pre>
";
	      }
	      ?>

PHP Documentation Group 													      OCI_ERROR(3)