What are the limitations of the OracleConnectionStringBuilder.RunOnceCommand?
Posted: Mon 10 Oct 2016 21:01
I created the code shown below. There are two RunOnceCommand statements, one that works, and one that returns an Invalid SQL error at Open(). What are the valid SQL statements that can be used in the RunOnceCommand?
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();