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:24:14 -0700 (PDT)
Message-ID: <1b865811-d2e1-4713-9f7b-c5be50ce27be_at_e35g2000yqc.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:24:14 -0700 (PDT)
Message-ID: <1b865811-d2e1-4713-9f7b-c5be50ce27be_at_e35g2000yqc.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
Well Sybrand, that's why I posted the question, if I had the knowledge, I would not have posted the question :)
Thanks Received on Wed Mar 25 2009 - 08:24:14 CDT