[PHP-DEV] Bug #1930: db_oracle.inc does not return Errno and Error from query method From: adamzg <email protected>
Date: 07/30/99

From: adamzg <email protected>
Operating system: Unix/appache
PHP version: 3.0.9
PHP Bug Type: Oracle related
Bug description: db_oracle.inc does not return Errno and Error from query method

Fix:

  function query($Query_String) {
      $this->connect();
      
      $this->Query_ID= ora_open($this->Link_ID);
      if(!ora_parse($this->Query_ID,$Query_String)) {
                  $this->Errno=ora_errorcode($this->Query_ID);
                  $this->Error=ora_error($this->Query_ID);
      } else {
        /* THIS IS THE FIX!! */
        if(ora_exec($this->Query_ID)) {
                $this->Errno=ora_errorcode($this->Query_ID);
                $this->Error=ora_error($this->Query_ID);
        }
        /* END OF FIX!! */
      }
      $this->Errno=ora_errorcode($this->Query_ID);
            $this->Error=ora_error($this->Query_ID);
      $this->Row=0;

      if($this->Debug) {
          printf("Debug: query = %s<br>\n", $Query_String);
          printf("<br>Debug: Query_ID: %d<br>\n", $this->Query_ID);
      }
      
      if(!$this->Query_ID) {
          $this->halt("Invalid SQL: ".$Query_String);
      }
      
      return $this->Query_ID;
  } 

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>