• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Oracle Live Invalid Table Name

 
Ranch Foreman
Posts: 883
8
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I had a similar error on a recent question that I asked.  I looked through my questions but I don't see it.   Is there a way to search for text on my posts?  

Please see the attached table to see that it exists.



ORA-00903: invalid table name

Oracle live will let me share my scripts.   I'd like to try it.   I think that you just go to the URL to find it.

This is where I create the schema:
https://livesql.oracle.com/apex/livesql/s/oyckv0q8q1zlb1nx6nga4wktu

This is the trouble Statement:
https://livesql.oracle.com/apex/livesql/s/oyckzjpanwwznneqwwjy480om

I can also try the publish command so that you could see the code directly inside of Oracle Live.

Best,

Kevin





table-name-error.png
[Thumbnail for table-name-error.png]
 
Marshal
Posts: 4519
572
VSCode Eclipse IDE TypeScript Redhat MicroProfile Quarkus Java Linux
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
You have a typo with the column name in the WHERE clause.

UPDATE PROVIDER_CONTRACT
SET   Specialty_Description = 'Chiropractic'
WHERE Specialty_Descripton = 'Chiropractor'
 
Marshal
Posts: 28244
95
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I have to say that "ORA-00903: invalid table name" is an outrageously misleading error message.
 
kevin Abel
Ranch Foreman
Posts: 883
8
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Ron,

My 62 year old eyes did not see this.  I don't think it is age related though.   I made the same mistakes 50 years ago.    

Paul,

The Oracle Live feedback works for issues relating to the tool.  Does anyone know if there is an Oracle Language feedback area?  Maybe I should go to Freemont, CA with a pickit sign.  

Kevin



 
Ron McLeod
Marshal
Posts: 4519
572
VSCode Eclipse IDE TypeScript Redhat MicroProfile Quarkus Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Simple issues like that are not always obvious, and it seems like Oracle's error messages can detour you into looking for a problem which doesn't actually exist.  Often, just using a simple text editor or IDE can help you quickly spot these kinds of problems.

For example, with Notepad++, if you paste-in both the table definition and the query, and then select some text, it will highlight all the places where that selection appears.  In this case double-clicking on the column name in the DDL portion would show that there was only one match in the DML portion where two were expected.

 
kevin Abel
Ranch Foreman
Posts: 883
8
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Ron,

That is a great idea.

I sent feedback in the Oracle Live application.   I told them about this particular error message making it difficult to debug.  I told them that I'd be good for going through the internal error handling logic to make it better if they gave me the project.   I also asked where is a good place to let them know which errors are not clear.

The error about the Table not existing happens with UPDATE.  I tried it with SELECT and it gave the error msg saying that the TABLE is missing as I would expect.

I wonder if they will respond.

Best,

Kevin
 
Saloon Keeper
Posts: 27819
196
Android Eclipse IDE Tomcat Server Redhat Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
The error message does not come from Oracle Live. It comes from the Oracle database client, possibly passed from the Oracle database server, although more likely expanded from a server error code.

Oracle and DB/2 were originally mainframe productsm designed to run on massive machines with less memory than an Apple Watch. While Oracle and IBM have spent a lot of work on adding more tiers to the top of the cake, no one has ever bothered to clean up the bottom. That's why the error messages are cryptic and the vendor-supplied support utilities are minimal.

It's ironic that the free and open-source databases are in many ways more functional than the stodgy and respectable Big Business commercial products, but systems like MySQL and PostgreSQL were formed when resources were no longer as limited and it was much harder for their authors to ignore user complaints.

Basically if you're not Fortune 500, don't expect much from the big commercial vendors.
 
Bartender
Posts: 217
7
Android Python Oracle Postgres Database Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Actually after pasting  https://livesql.oracle.com/apex/livesql/s/oyckv0q8q1zlb1nx6nga4wktu in a SQL sheet, then resetting the SQL sheet I received the "right" error message.

I suspect that  the posted SQL code and the error message "ORA-00903: invalid table name" do not match. When the name of the table is deliberately changed "ORA-00942: table or view does not exist"  occurs. My only guess is the the error "... invalid table name" is caused by some unicode junk from copy&paste.








 
Roland Mueller
Bartender
Posts: 217
7
Android Python Oracle Postgres Database Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Roland Mueller wrote:Actually after pasting  https://livesql.oracle.com/apex/livesql/s/oyckv0q8q1zlb1nx6nga4wktu in a SQL sheet, then resetting the SQL sheet I received the "right" error message.
...


My first sentence may be not totally understandable (not even if I would have wrote it in German    ): of course I was executing the code behind the link and only after that resetting the sheet  and executing the errorness SQL in the sheet.
 
Tim Holloway
Saloon Keeper
Posts: 27819
196
Android Eclipse IDE Tomcat Server Redhat Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
That's why the actual error message is "ORA-00903". Because you can look it up in English in the English-language Oracle messages guide or look it up in German in the German-language Oracle messages guide. Unfortunately, regardless of the language, the message is virtually useless.

If I got an error message beginning with ILF255I, I'd likewise know that I'd need to consult an IBM Messages and Codes manual, and that in fact, the Fortran Messages and Codes for Information-level message 255. Which, no doubt would be equally cryptic. That's just how mainframe error messages are.
 
Roland Mueller
Bartender
Posts: 217
7
Android Python Oracle Postgres Database Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Tim Holloway wrote:That's why the actual error message is "ORA-00903". Because you can look it up in English in the English-language Oracle messages guide or look it up in German in the German-language Oracle messages guide. Unfortunately, regardless of the language, the message is virtually useless.

If I got an error message beginning with ILF255I, I'd likewise know that I'd need to consult an IBM Messages and Codes manual, and that in fact, the Fortran Messages and Codes for Information-level message 255. Which, no doubt would be equally cryptic. That's just how mainframe error messages are.


The error message when I used the origiginal code was ORA-00904. rather than 00903. Please read my first post.
 
Tim Holloway
Saloon Keeper
Posts: 27819
196
Android Eclipse IDE Tomcat Server Redhat Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Roland Mueller wrote:

Tim Holloway wrote:That's why the actual error message is "ORA-00903". Because you can look it up in English in the English-language Oracle messages guide or look it up in German in the German-language Oracle messages guide. Unfortunately, regardless of the language, the message is virtually useless.

If I got an error message beginning with ILF255I, I'd likewise know that I'd need to consult an IBM Messages and Codes manual, and that in fact, the Fortran Messages and Codes for Information-level message 255. Which, no doubt would be equally cryptic. That's just how mainframe error messages are.


The error message when I used the origiginal code was ORA-00904. rather than 00903. Please read my first post.



Either number, look up in the Oracle messages manual. The message will differ, but the futility remains. Alles is verloren.

I think the first 2-3 digits of the Oracle number indicate what part of Oracle the error came from, just as the "LF" in ILF225I indicates the Fortran Language Program Product from IBM. But I no longer remember for certain. And for the most part, who cares?
 
reply
    Bookmark Topic Watch Topic
  • New Topic