It seems there was a change between AR 2.1.0 and 2.1.1. The table
name is now being quoted in oci8, which causes the table not to be
found. A script that uses this code works with 2.1.0, but not 2.1.1.
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."
Please let me know if this is not the proper forum for this
information.
Thanks,
Scott Robertson
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Core" group.
To post to this group, send email to rubyonrails-core@googlegroups.com
To unsubscribe from this group, send email to
rubyonrails-core+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-core?hl=en
-~----------~----~----~----~------~----~------~--~---
On Thu, Sep 18, 2008 at 1:39 PM, Scott Robertson <R.Scott.Robertson@gmail.com> wrote:> > It seems there was a change between AR 2.1.0 and 2.1.1. The table > name is now being quoted in oci8, which causes the table not to be > found. A script that uses this code works with 2.1.0, but not 2.1.1. > > 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." > > 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 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Core" group. To post to this group, send email to rubyonrails-core@googlegroups.com To unsubscribe from this group, send email to rubyonrails-core+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-core?hl=en -~----------~----~----~----~------~----~------~--~---
On Sep 18, 3:04 pm, "Jeremy Kemper" <jer...@bitsweat.net> wrote:> On Thu, Sep 18, 2008 at 1:39 PM, Scott Robertson > > > > <R.Scott.Robert...@gmail.com> wrote: > > > It seems there was a change between AR 2.1.0 and 2.1.1. The table > > name is now being quoted in oci8, which causes the table not to be > > found. A script that uses this code works with 2.1.0, but not 2.1.1. > > > 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." > > > 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, > jeremyThanks for the quick response, you were right, that works. Scott --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Core" group. To post to this group, send email to rubyonrails-core@googlegroups.com To unsubscribe from this group, send email to rubyonrails-core+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-core?hl=en -~----------~----~----~----~------~----~------~--~---