mqseries_connx(3) [php man page]

MQSERIES_CONNX(3)							 1							 MQSERIES_CONNX(3)

mqseries_connx - MQSeries MQCONNX

SYNOPSIS

       void mqseries_connx (string  $qManagerName, array  &$connOptions, resource  &$hconn, resource  &$compCode, resource  &$reason)

DESCRIPTION

	The  mqseries_connx(3)	(MQCONNX)  call connects an application program to a queue manager. It provides a queue manager connection handle,
       which is used by the application on subsequent MQ calls.

PARAMETERS

	      o $qManagerName
		-Name of queue manager.Name of the queue manager the application wishes to connect.

	      o $connOps
		-Options that control the action of functionSee also the MQCNO structure.

	      o $hConn
		-Connection handle.This handle represents the connection to the queue manager.

	      o $compCode
		-Completion code.

	      o $reason
		-Reason code qualifying the compCode.

RETURN VALUES

       No value is returned.

EXAMPLES

       Example #1

	      mqseries_connx(3) example

	      <?php
		  $mqcno = array(
		      'Version' => MQSERIES_MQCNO_VERSION_2,
		      'Options' => MQSERIES_MQCNO_STANDARD_BINDING,
		      'MQCD' => array('ChannelName' => 'MQNX9420.CLIENT',
		      'ConnectionName' => 'localhost',
		      'TransportType' => MQSERIES_MQXPT_TCP)
		  );

		  mqseries_connx('MQNX9420', $mqcno, $conn, $comp_code,$reason);
		  if ($comp_code !== MQSERIES_MQCC_OK) {
		      printf("Connx CompCode:%d Reason:%d Text:%s<br>
", $comp_code, $reason, mqseries_strerror($reason));
		      exit;
		  }

	      ?>

       Example #2

	      mqseries_connx(3) example using SSL connection & OCSP Responder URL

	      <?php
		  $mqcno = array(
		      'Version' => 4, //MQCNO_VERSION_4
		      'Options' => MQSERIES_MQCNO_STANDARD_BINDING,
		      'MQCD' => array(
			  'Version' => 7, //MQCD_VERSION_7
			  'ConnectionName' => 'localhost',
			  'TransportType' => MQSERIES_MQXPT_TCP,
			  'ChannelName' => 'CONNECTIONCHANNEL',
			  'SSLCipherSpec' => 'NULL_SHA'
		      ),
		      'MQSCO' => array(
			  'KeyRepository' => '/var/mqm/qmgrs/QUEUEMGR/ssl/key', //Local path where the SSL key repository can be found
			  'MQAIR' => array(
			      'Version' => 2, //MQAIR_VERSION_2
			      'AuthInfoType' => 2, //MQAIT_OCSP
			      'OCSPResponderURL' => 'http://dummy.OCSP.responder'
			  )
		      )
		  );

		  mqseries_connx('QUEUEMGR', $mqcno, $conn, $comp_code,$reason);
		  if ($comp_code !== MQSERIES_MQCC_OK) {
		      printf("Connx CompCode:%d Reason:%d Text:%s<br>
", $comp_code, $reason, mqseries_strerror($reason));
		      exit;
		  }

	      ?>

SEE ALSO

       mqseries_disc(3).

PHP Documentation Group 													 MQSERIES_CONNX(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)