Re: oracle sql plus - modified table column - but modification not showing in odbc connection

From: BookerT <>
Date: Wed, 25 Mar 2009 06:25:57 -0700 (PDT)
Message-ID: <>

On Mar 25, 1:35 am, wrote:
> On Tue, 24 Mar 2009 14:40:34 -0700 (PDT), BookerT <>
> 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

Original text of this message