Oracle tablename problem

From: Mavis Hearnden <M.A.Hearnden_at_lut.ac.uk>
Date: Tue, 14 Feb 1995 17:05:49 GMT
Message-ID: <D4025p.2yB_at_lut.ac.uk>

A user on our system has been using Visual Basic on a PC together with SQL*Net to access Oracle data (Oracle v6.0.37.. on an HP 9000/8??) .
The program he wrote created Oracle tables which had names including lower case letters. (eg zone, Products).
When he tried to access these tables, he couldn't. Trying to rename/drop them didn't work either.

I tried, using SQLPlus and Pro*Fortran (yes, but I'm happier with Fortran than C); and again no success.
SQL of all flavours clearly changes tablenames into uppercase before passing to the RDBMS.

Only thing I could do was to go to the original SYS tables (obj$,tab$, etc) and delete the tables by number. A horrible warning to all.
Anyone else had this happen?
I've not seen the original VBasic programs, so I dont know exactly what was going on.

Mavis

--
Mavis Hearnden
Computer Services
Loughborough University,
Leicestershire,England

Received on Tue Feb 14 1995 - 18:05:49 CET

This message: [ Message body ]
Next message: respec_at_pegasus.unm.edu: "Re: Oracle tablename problem"
Previous message: Greg Schueman: "Re: Is it possible to compile Pro*C and C++ code together using C++ compilser?"
Next in thread: Scott Urman: "Re: Oracle tablename problem"
Reply: respec_at_pegasus.unm.edu: "Re: Oracle tablename problem"
Reply: Scott Urman: "Re: Oracle tablename problem"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message