Issues

ZF-7267: Oracle Adapter insert function adds quote to tablename and causes the query to throw (table/view not found) exception

Description

Oracle Adapter insert function adds quote to tablename and causes the query to throw (table/view not found) exception.

I am using Oracle Database Express Edition.

The following is the php statement in zend framework

    // build the statement
    $sql = "INSERT INTO "
         . $this->quoteIdentifier($table, true)
         . ' (' . implode(', ', $cols) . ') '
         . 'VALUES (' . implode(', ', $vals) . ')';

The function starts working once you change the above line to replacing $this->quoteIdentifier($table, true) with $table:

    // build the statement
    $sql = "INSERT INTO "
         . $table 
         . ' (' . implode(', ', $cols) . ') '
         . 'VALUES (' . implode(', ', $vals) . ')';

Comments

See autoQuoteIdentifier options in the manual.

Closed as not an issue