Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ODBC SQLColumns() and Oracle synonyms....

Re: ODBC SQLColumns() and Oracle synonyms....

From: <jocave_at_my-deja.com>
Date: 2000/08/09
Message-ID: <8msf4o$8pn$1@nnrp1.deja.com>#1/1

In article <399070E7.6E636C1A_at_yahoo.com>,   Gregory Scarborough <scargs_at_yahoo.com> wrote:
> I am experiencing problems using SQLColumns() against Oracle synonyms.
> SQLColumns() returns all of the rows in the synonym (as it should) but
> it also returns rows that used to be in the table. For instance, if
 the
> table that is the target of the synonym is defined to have a column
> TOTAL NUMBER(5) and then that table is dropped and recreated with a
> column TOTAL VARCHAR2(5), SQLColumns() will return two entries for the
> TOTAL column in its result set. One with a NUMBER type and the other
> with a VARCHAR2 type.
>
> However, if I run SQLColumns() against the table that is the target of
> the synonym, I get the correct results. The problem only manifests
> itself when an Oracle synonym is used.
>
> The problem is recreatable using either the Microsoft Oracle ODBC
 Driver
> or the Oracle 8.1.5 ODBC Driver. I have tested against Oracle 8.0.5
 and
> Oracle 8.1.5 databases and get the same results. I have also tried to
> do something similar with DB2 5.2 but was unable to recreate the
> problem.

This sounds like buggy behavior.

Unfortunately, I've been unable to reproduce your problem on my system. Can you provide the exact SQL you're using to create the table, create the synonym, re-create the table, etc. as well as the exact ODBC calls you're making? Note that the simpler and easier the information you're able to provide, the more likely I am to try to get to the bottom of it.

Feel free to e-mail this information to me personally at Justin.Cave_at_oracle.com rather than posting to these various groups.

Justin Cave
Oracle ODBC Development
Opinions expressed herein are my own and do not reflect those of Oracle

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Aug 09 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US