Problems with OracleCommandBuilder

From: emMBee (mustafa.bilal_at_gmail.com)
Date: 07/19/04 

Date: 19 Jul 2004 15:51:10 -0700

Hi,

I am using the Microsoft Oracle Data Provider
(System.Data.OracleClient.dll) to access an Oracle DB.
OracleCommandBuilder along with OracleDataAdapter is being used to
update,delete and insert data into a table from the corresonding
DataSet.

Here is the code..
---------------------------------------

OracleConnection Conn = new OracleConnection(".....");
Conn.Open();

// Table1 is a typical table with a defined primary key.
OracleCommand Cmd = new OracleCommand( "SELECT * from TABLE1", Conn
);

OracleDataAdapter Adpt = new OracleDataAdapter();
Adpt.SelectCommand = Cmd;

// create the command builder
OracleCommandBuilder Bldr = new OracleCommandBuilder( Adpt);

//At this point the OracleDataAdapter the CommandBuilder should have
created all the respective commands in the DataAdapter. However the
DataAdapter still has its UpdateCommand etc. undefined. (null)

// the following would throw NullReference Exception.
MessageBox.Show( Adpt.UpdateCommand.CommandText );

--------------------------------------

Is this a known issue? Why does the CommandBuilder not create the
UpdateCommand, InsertCommand and the DeleteCommand? Interestingly, No
exceptions are raised at all. Does the MS oracle provider have any
such known bugs? could it be an issues specific to oracle 8.i client ?

any help would be greatly appreciated.
thanks 

--
MB

Relevant Pages