Code: Select all
OracleConnectionStringBuilder myCSB = new OracleConnectionStringBuilder();
myCSB.Direct = true;
myCSB.Server = "myServer.myDomain.com";
myCSB.UserId = "myUserid";
myCSB.Password = "myPassword";
myCSB.Sid = "mySid";
myCSB.Home = "myOracleHome";
myCSB.Port = 9999;
myCSB.PersistSecurityInfo = true;
// This one works
// myCSB.RunOnceCommand = "INSERT INTO MY_TABLE (COLUMN1, COLUMN2) Values ('First', 'Second')";
// This one returns an "ORA-00900: invalid SQL statement" message
// myCSB.RunOnceCommand = "EXECUTE MY_PACKAGE.ADD('First', 'Second')";
OracleConnection myConnection = new OracleConnection(myCSB.ConnectionString);
myConnection.Open();