we can access the table lower- and uppercase in sqlplus, only Delphi makes
single quotes around tables
and if it thats not uppercase, the table won't be found.
> -----Oorspronkelijk bericht-----
> Van: Dennis Taylor [SMTP:ismgr_at_pctc.com]
> Verzonden: 8-dec-00 16:46
> Aan: Multiple recipients of list ORACLE-L
> Onderwerp: RE: delphi-oracle
>
> can you access the table normally using sqlplus? I'm thinking of the
> possibility that the table was created with name in quotes and actually
> contains some lower-case letters.
>
> Can you display the whole sql statement before executing it? In DOA, for
> instance, there's a DEBUG property that displays any sql stmt before
> execution. That's cleared up many a problem for me.
>
>
> At 02:40 AM 12/8/00 -0800, you wrote:
> >we are using BDE to connect to Oracle
> >
> >> -----Oorspronkelijk bericht-----
> >> Van: Dennis Taylor [SMTP:ismgr_at_pctc.com]
> >> Verzonden: 8-dec-00 04:28
> >> Aan: Multiple recipients of list ORACLE-L
> >> Onderwerp: Re: delphi-oracle
> >>
> >> No, in fact we generally have everything in lower-case (except stuff in
> >> quotes) and it works fine.
> >>
> >> What are you using to connect from Delphi to Oracle? odbc? BDE? DOA?
> >>
> >> At 12:26 AM 12/7/00 -0800, GKor_at_rdw.nl wrote:
> >> >hi everyone
> >> >
> >> >Has anyone of you problems with lowercase table names coded in Delphi
> 4
> >> and
> >> >you get the
> >> >message :
> >> > ORA-00942: table or view does not exist"
> >> >if you query this on oracle ?
> >> >
> >> >
> >> >thanks
> >> >g.g. kor
> >> >rdw the netherlands
> >> >
> >> >--
> >> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >> >--
> >> >Author:
> >> > INET: GKor_at_rdw.nl
> >> >
> >> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >> >San Diego, California -- Public Internet access / Mailing Lists
> >> >--------------------------------------------------------------------
> >> >To REMOVE yourself from this mailing list, send an E-Mail message
> >> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >> >the message BODY, include a line containing: UNSUB ORACLE-L
> >> >(or the name of mailing list you want to be removed from). You may
> >> >also send the HELP command for other information (like subscribing).
> >> >
> >> >
> >> ---
> >> Dennis Taylor
> >> ---
> >> Don't worry about people stealing your ideas. If your ideas
> >> are any good,
> >> you'll have to ram them down people's throats.
> >> --
> >> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >> --
> >> Author: Dennis Taylor
> >> INET: ismgr_at_pctc.com
> >>
> >> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >> San Diego, California -- Public Internet access / Mailing Lists
> >> --------------------------------------------------------------------
> >> To REMOVE yourself from this mailing list, send an E-Mail message
> >> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >> the message BODY, include a line containing: UNSUB ORACLE-L
> >> (or the name of mailing list you want to be removed from). You may
> >> also send the HELP command for other information (like subscribing).
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author:
> > INET: GKor_at_rdw.nl
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
> >
> >
> ---
> Dennis Taylor
> ---
> Don't worry about people stealing your ideas. If your ideas
> are any good,
> you'll have to ram them down people's throats.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Dennis Taylor
> INET: ismgr_at_pctc.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Sun Dec 10 2000 - 02:12:17 CST
