Active Record 2.1.1- oci8 - Table Name Quoted

Rails
1

The same code that worked with AR 2.1.0 now doesn’t work in 2.1.1. It
seems like the table name is now being quoted which oci8 doesn’t like.

In sqlplus quoting the table name causes the table name
(“SCHEMA.table_name”) not to be found, where the same query with non-
quoted table name works fine. Was there a change in 2.1.1 that stated
quoting table names with oci8?

If it helps I am prepending the schema name like this:

Table_Name.table_name_prefix = “SCHEMANAME.”

Thanks,
Scott Robertson

2

On Thu, Sep 18, 2008 at 1:39 PM, Scott Robertson
[email protected] wrote:

If it helps I am prepending the schema name like this:
Table_Name.table_name_prefix = “SCHEMANAME.”

Please let me know if this is not the proper forum for this
information.

Without quoting, the identifier is case-insensitive. Use the correct
case for your table_name_prefix and the problem’s solved.

Best,
jeremy

3

On Sep 18, 3:04 pm, “Jeremy K.” [email protected] wrote:

In sqlplus quoting the table name causes the table name
Without quoting, the identifier is case-insensitive. Use the correct
case for your table_name_prefix and the problem’s solved.

Best,
jeremy

Thanks for the quick response, you were right, that works.

Scott