RE: [phplib] More oci8 woes... From: Francesco.Marsan <email protected>
Date: 06/27/00

I have found this problem as well (BEGIN TRANSACTION, END TRANSACTION, those are not Oracle instructions). What you need to do is the following:

- comment the BEGIN TRANSACTION line of ct_split_sql.inc (function ac_store)
- " " END TRANSACTION " " "
- add this line just before return $ret (function ac_store);
        $this->db->query("COMMIT");

HTH
-f

-----Original Message-----
From: Kevin Porterfield [mailto:kpmd <email protected>]
Sent: Tuesday, June 27, 2000 3:18 AM
To: phplib <email protected>
Subject: [phplib] More oci8 woes...

I have to say i truly appreciate all of the help everyone has given on this
mailing list. Extremely helpful. I have run into yet another OCI8 error that
I can't seem to shake or track down. I am now using db_oci8.inc with
CT_Split_SQL. When I call page_close and it tries to write the session data
to the db I receive the following errors:

Warning: OCIStmtExecute: ORA-06550: line 1, column 17: PLS-00103:
Encountered the symbol "end-of-file" when expecting one of the following: :=
. ( @ % ; in db_oci8.inc on line 54
Debug: query = BEGIN TRANSACTION

Warning: OCIStmtExecute: ORA-00900: invalid SQL statement in db_oci8.inc on
line 54
Debug: query = END TRANSACTION

line 54 of db_oci8.inc is in the query function

  function query($Query_String) {
      $this->connect();

      $this->Parse=OCIParse($this->Link_ID,$Query_String);
      if(!$this->Parse) {
           $this->Error=OCIError($this->Parse);
 54-> } else { OCIExecute($this->Parse);
          $this->Error=OCIError($this->Parse);
      }

      $this->Row=0;

      if($this->Debug) {
          printf("Debug: query = %s<br>\n", $Query_String);
      }

      if ($this->Error["code"]!=1403 && $this->Error["code"]!=0 &&
$this->sqoe)
      echo "<BR><FONT color=red><B>".$this->Error["message"]."<BR>Query
:\"$Query_String\"</B></FONT>";
      return $this->Parse;
  }

Again, any help or insight would be appreciated. You guys really have been
very helpful. Many thanks.

kp
kpmd <email protected>

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>