TESTING MOODLE 2.0 OCI DRIVER WITH oci8.statement_cache_size = ".ini_get('oci8.statement_cache_size')." (from php.ini)";

$table = new xmldb_table('unit_table');
$table->add_field('id', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, XMLDB_SEQUENCE, null);
$table->add_field('course', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, '0');
$table->add_field('name', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, null, null, '0');
$table->add_key('primary', XMLDB_KEY_PRIMARY, array('id'));

if ($dbman->table_exists($table)) {
    $dbman->drop_table($table);
}
$dbman->create_table($table);
echo "
Created table unit_table (id, course, name). Ok
";

$rs = $DB->get_recordset('unit_table');
echo "
Selected 0 records from table. Ok
";
$rs->close();

$table2 = new xmldb_table('unit_table');
$table2->add_field('id', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, XMLDB_SEQUENCE, null);
$table2->add_field('course', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, '0');
$table2->add_key('primary', XMLDB_KEY_PRIMARY, array('id'));

if ($dbman->table_exists($table2)) {
    $dbman->drop_table($table2);
    echo "
Dropped table unit_table (id, course, name). Ok
";
}
$dbman->create_table($table2);
echo "
Created table unit_table (id, course). Ok
";

try {
    $rs2 = $DB->get_recordset('unit_table');
    $rs2->close();
    echo "
Selected 0 records from table. Ok
";
    echo "
TEST FINISHED OK!
";
    $status = 'OK!';
} catch (moodle_exception $e) {
    echo "
Unable to select records from table. Error!
";
    echo "
TEST FINISHED WITH ERROR!
";
    $status = "ERROR! $e->error - $e->sql";
}
if ($dbman->table_exists($table2)) {
    $dbman->drop_table($table2);
    echo "
Dropped table unit_table (id, course). Ok
";
}

echo "
Please report this information:
";
echo "
    - Operating System: " . PHP_OS . "
";
echo "
    - PHP Version: " . PHP_VERSION . "
";
echo "
    - Database: " . implode($DB->get_server_info(), ", ") . "
";
echo "
    - OCI Version: (you can get it from the phpinfo page, OCI8 section)
";
echo "
    - oci8.statement_cache_size: " . ini_get('oci8.statement_cache_size') . "
";
echo "
    - Test Result: " . $status . "
";