Re: oracle sql plus - modified table column - but modification not showing in odbc connection
From: BookerT <chipw_at_mierbo.com>
Date: Wed, 25 Mar 2009 06:25:57 -0700 (PDT)
Message-ID: <564b6ecc-d79d-4797-a3e0-4027e28eff18_at_a12g2000yqm.googlegroups.com>
On Mar 25, 1:35 am, sybra..._at_hccnet.nl wrote:
> On Tue, 24 Mar 2009 14:40:34 -0700 (PDT), BookerT <ch..._at_mierbo.com>
> wrote:
>
> >Robert, the other basic thing that we missed, is I did not use the
> >commit work; command and that seemed to make a difference as well. So
> >it was not an Access problem, but a SQL issue, .. does that make sense?
>
> It makes no sense at all, as every DDL is automatically committed.
> You really need some knowledge brushing up.
> As soon as you change any table in Oracle, you'll need to *reattach*
> it in Access, or the changed definition will not show up.
> So it IS an Access problem, and a problem with your lack of knowledge.
>
> --
> Sybrand Bakker
> Senior Oracle DBA
Date: Wed, 25 Mar 2009 06:25:57 -0700 (PDT)
Message-ID: <564b6ecc-d79d-4797-a3e0-4027e28eff18_at_a12g2000yqm.googlegroups.com>
On Mar 25, 1:35 am, sybra..._at_hccnet.nl wrote:
> On Tue, 24 Mar 2009 14:40:34 -0700 (PDT), BookerT <ch..._at_mierbo.com>
> wrote:
>
> >Robert, the other basic thing that we missed, is I did not use the
> >commit work; command and that seemed to make a difference as well. So
> >it was not an Access problem, but a SQL issue, .. does that make sense?
>
> It makes no sense at all, as every DDL is automatically committed.
> You really need some knowledge brushing up.
> As soon as you change any table in Oracle, you'll need to *reattach*
> it in Access, or the changed definition will not show up.
> So it IS an Access problem, and a problem with your lack of knowledge.
>
> --
> Sybrand Bakker
> Senior Oracle DBA
Also, the data did not change until I used the commit work command as well, so go figure, and that was the data, not the meta data that did not refresh. Received on Wed Mar 25 2009 - 08:25:57 CDT