Home » Infrastructure » Windows » ODP.NET table dimensions don't 'alter' (ODP.NET client
icon5.gif  ODP.NET table dimensions don't 'alter' [message #307276] Tue, 18 March 2008 05:34
Messages: 1
Registered: March 2008
Junior Member
Hi folks,

I have a problem to do with altering table columns and queries relating to that table thereafter.

I have a table which has been queried using an OracleDataAdapter.Fill(DataSet), if I add a column using say using an OracleCommand.ExecuteNonQuery() or sqlplus session (and doing a 'commit' after) the column does not show up on subsequant 'Fill' queries unless I reopen the DB connection.

If I remove a column the symptoms are different and I receive a "ORA-01007: variable not in select list" even if I have created a new OracleDataAdapter object.

I presume there is some caching going on at the driver level but I can't get around this other than closing and reopening the OracleConnection object.

Any ideas how to purge this cache or a setting of some sort I can change to stop it from doing this?

Previous Topic: Oracle Homes (Mess up folders)
Next Topic: Change Password
Goto Forum:

Current Time: Sat Jun 10 10:19:50 CDT 2023