BASE work with Oracle 10

  • 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/
    function baseTableExists($table)
        ++if ($this->DB_type == "oci8") $table=strtoupper($table);
        if ( in_array($table, $this->DB->MetaTables()) )
            return 1;
            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