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;
}
Because in function "baseTableExists" oracle return upper name. And in function "baseExecute" not always correctly understand symbol ";" in finish requets to oracle base.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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.
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";
...
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