Re: [R] Dealing with schema in RODBC

On Fri, 9 Nov 2007, Mark Lyman wrote: > Thanks for your suggestion Marc. I saw that on some Oracle-related > web-sites, but something in the way RODBC functions verify the existance of > a table does not accept that naming structure. For example: > >> sqlColumns(eids, "EIDS.TEST_ARTCL_INST") > Err

Re: [R] Dealing with schema in RODBC

Thanks for your suggestion Marc. I saw that on some Oracle-related web-sites, but something in the way RODBC functions verify the existance of a table does not accept that naming structure. For example: > sqlColumns(eids, "EIDS.TEST_ARTCL_INST") Error in sqlColumns(eids, "EIDS.TEST_ARTCL_INST") :

Re: [R] Dealing with schema in RODBC

On Wed, 2007-11-07 at 22:15 +, Mark Lyman wrote: > Is there a way to get a table in a certain schema? The Oracle database I am > using has a table by the same name in two different schemas. This creates > problems in sqlUpdate because to sqlUpdate there are duplicate columns. The > following

[R] Dealing with schema in RODBC

Is there a way to get a table in a certain schema? The Oracle database I am using has a table by the same name in two different schemas. This creates problems in sqlUpdate because to sqlUpdate there are duplicate columns. The following is part of the output of sqlColumns: sqlColumns(eids, "TEST