# Active Record 2.1.1- oci8 - Table Name Quoted

**URL:** <https://www.ruby-forum.com/t/active-record-2-1-1-oci8-table-name-quoted/148618>\
**Category:** Rails\
**Created:** [September 15, 2008, 4:48pm UTC](https://www.ruby-forum.com/t/active-record-2-1-1-oci8-table-name-quoted/148618 "2008-09-15T16:48:55Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Scott\_Robertson](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/4da419/32.png) [@Scott\_Robertson](https://www.ruby-forum.com/u/Scott_Robertson)\
**Post date:** [September 15, 2008, 4:48pm UTC](https://www.ruby-forum.com/t/active-record-2-1-1-oci8-table-name-quoted/148618/1 "2008-09-15T16:48:55Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Scott\_Robertson](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/4da419/32.png) [@Scott\_Robertson](https://www.ruby-forum.com/u/Scott_Robertson)\
**Post date:** [September 19, 2008, 4:07pm UTC](https://www.ruby-forum.com/t/active-record-2-1-1-oci8-table-name-quoted/148618/2 "2008-09-19T16:07:26Z")

</div>

On Thu, Sep 18, 2008 at 1:39 PM, Scott Robertson  
[removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) 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

---

<div class="post-metadata">

**Author:** ![Scott\_Robertson](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/4da419/32.png) [@Scott\_Robertson](https://www.ruby-forum.com/u/Scott_Robertson)\
**Post date:** [September 19, 2008, 4:36pm UTC](https://www.ruby-forum.com/t/active-record-2-1-1-oci8-table-name-quoted/148618/3 "2008-09-19T16:36:14Z")

</div>

On Sep 18, 3:04 pm, “Jeremy K.” [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) 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