BASE work with Oracle 10

BASE-user
SAleX
2008-12-11
2013-06-03
  • SAleX

    SAleX - 2008-12-11

    Now BASE 1.4.1 (lara) not work with Oracle 10.
    If you want it work, then need make next. In file includes/base_db.inc.php:
    function baseTableExists($table)
    {
        ++if ($this->DB_type == "oci8") $table=strtoupper($table);
        if ( in_array($table, $this->DB->MetaTables()) )
            return 1;
        else
            return 0;
    }

    function baseExecute ...
    ...
         if ($this->DB_type == "mssql")
            $sql = eregi_replace("''", "NULL", $sql);
       ++if ($this->DB_type == "oci8") {
        ++if (!strpos($sql, 'TRIGGER')) {
        ++    if (substr($sql, strlen($sql)-1, strlen($sql))==';')   $sql=substr($sql, 0, strlen($sql)-1);
        ++}
    ++}
    ...

    Because in function "baseTableExists" oracle return upper name. And in function "baseExecute" not always correctly understand symbol ";" in finish requets to oracle base.

     
    • SAleX

      SAleX - 2008-12-11

      function basePConnect (
           ...
           --$sql = "SELECT vseq FROM `schema`";
           ++$sql = "SELECT vseq FROM schema";
           if ($this->DB_type == "mysql") $sql = "SELECT vseq FROM `schema`";
           if ($this->DB_type == "mssql") $sql = "SELECT vseq FROM [schema]";
           --if ($this->DB_type == "postgres") $sql = "SELECT vseq FROM schema";
           ...

       
    • Juergen Leising

      Juergen Leising - 2008-12-18

      Hello asavenkov,

      I have applied your patch to CVS.  Some problems with
      regard to Oracle 10 have already been reported.  So
      we are grateful for any fix trying to resolve these.

      Thank you very much, indeed.

      Bye, bye

      Juergen Leising

       

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks