New column added to old table causes ORA-00904

  • Thread starter Thread starter Jim Brandley
  • Start date Start date
J

Jim Brandley

I added a new column to an old table, and any time I try to add it to a
select, I get an ORA-00904 error. I'm using the MS OracleDataProvider
for DotNet, and Oracle 9.2.0.4.0. Experimenting has proven that any new
column on any table produces the same error. I have renamed the column,
dropped and re-added, and tried various simple names and a variety of
datatypes.

Has anyone else ever seen this problem?
 
Found it - another developer changed the way the connect string was
built. My changes were not applied to the same instance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ORA-01406: fetched column value was truncated 4
ORA-03113 error when updating an oracle clob column via a view 0
ORA-01461 while moving data from sqlserver to oracle 3
(C#/2.0) ORA-01036 Error When Upd/Ins/Del from Gridview 10
Insert c# DateTime object to Oracle Table using OleDbDataAdapter 5
Oracle Stored Procedure Problems 3
Adding columns to SQL Server tables dynamically 9
Create New Table/Column 1

Back
Top