diff options
-rwxr-xr-x | doc/oracle | 51 | ||||
-rwxr-xr-x | web/oracle | 51 |
2 files changed, 60 insertions, 42 deletions
diff --git a/doc/oracle b/doc/oracle index eef9e2717fb..921954aef0b 100755 --- a/doc/oracle +++ b/doc/oracle @@ -10,6 +10,8 @@ <li>Works with Oracle 8i</li> + <li>Untested, but should work with Oracle 9i</li> + <li>Uses the Oracle CLI (Call Level Interface) which is a C library (API) for the Oracle Client software</li> @@ -49,14 +51,21 @@ System.Data.OracleClient.build nant build file.</li> <li>Can retrieve data via ExecuteReader and OracleDataReader. Currently, - only simple character - data is supported. ExecuteScalar() still needs to be imlemented.</li> + supports character, numeric, some date data types. ExecuteScalar + also works.</li> + + <li>Simple input parameters (character and numeric data) can now + be used in SQL queries. Output parameters do not yet work.</li> <li>OracleException and Error handling exists now.</li> + + <li>Message handling needs to be added for non-critical messages + received from Oracle</li> - <li>Handling of various data types need to be handled</li> + <li>Handling of various data types need to be added.</li> - <li>Data Adapter needs to be created. Tim has started on it.</li> + <li>Data Adapter exists, and a DataSet can be filled using it. The + Data Adapter is abstract enough that it should work as expected.</li> <li>Lots of missing functionality and bugs.</li> @@ -69,12 +78,12 @@ ** Action Plan <ul> - <li>Be able to retrieve results via a data reader</li> - <li>Parameters support</li> - <li>transactions</li> + <li>Be able to retrieve results via a data reader (WORKING)</li> + <li>Parameters support (IN PROGRESS)</li> + <li>transactions (WORKING)</li> <li>Stored Procedures, Functions, and Packages support</li> - <li>Be able to fill a DataTable in a DataSet via a data adapter</li> - <li>Support for Oracle 8i and 9i</li> + <li>Be able to fill a DataTable in a DataSet via a data adapter (IN PROGRESS)</li> + <li>Support for Oracle 8i and 9i (UNKNOWN)</li> <li>Support LOBs</li> <li>Support all the data types</li> <li>Implement Connection pooling</li> @@ -90,7 +99,7 @@ <li>Have access to an Oracle 8i database or download it from <a href="http://www.oracle.com/">Oracle</a>. If you are connecting remotely to an Oracle database, you need the Oracle client software. - Registration to the Oracle Technology Network is free. If installing on Linux, + Registration to the <a href="http://technet.oracle.com/">Oracle Technology Network</a> is free. If installing on Linux, I suggest you do a lot of searching to see how others installed Oracle on Linux.</li> <li>Make sure System.Data.OracleClient.dll assembly is built, if not, go @@ -114,33 +123,33 @@ public class Test { - public static void Main(string[] args) + public static void Main (string[] args) { string connectionString = "Data Source=testdb;" + "User ID=scott;" + "Password=tiger;"; IDbConnection dbcon; - dbcon = new OracleConnection(connectionString); - dbcon.Open(); - IDbCommand dbcmd = dbcon.CreateCommand(); + dbcon = new OracleConnection (connectionString); + dbcon.Open (); + IDbCommand dbcmd = dbcon.CreateCommand (); string sql = "SELECT ename, job FROM scott.emp"; dbcmd.CommandText = sql; - IDataReader reader = dbcmd.ExecuteReader(); - while(reader.Read()) { + IDataReader reader = dbcmd.ExecuteReader (); + while (reader.Read ()) { string employeeName = reader["ename"]; string job = reader["job"]; - Console.WriteLine("Employee Name: {0} Job: {1}", + Console.WriteLine ("Employee Name: {0} Job: {1}", employeeName, job); } // clean up - reader.Close(); + reader.Close (); reader = null; dbcmd.CommandText = sql; - dbcmd.ExecuteNonQuery(); - dbcmd.Dispose(); + dbcmd.ExecuteNonQuery (); + dbcmd.Dispose (); dbcmd = null; - dbcon.Close(); + dbcon.Close (); dbcon = null; } } diff --git a/web/oracle b/web/oracle index eef9e2717fb..921954aef0b 100755 --- a/web/oracle +++ b/web/oracle @@ -10,6 +10,8 @@ <li>Works with Oracle 8i</li> + <li>Untested, but should work with Oracle 9i</li> + <li>Uses the Oracle CLI (Call Level Interface) which is a C library (API) for the Oracle Client software</li> @@ -49,14 +51,21 @@ System.Data.OracleClient.build nant build file.</li> <li>Can retrieve data via ExecuteReader and OracleDataReader. Currently, - only simple character - data is supported. ExecuteScalar() still needs to be imlemented.</li> + supports character, numeric, some date data types. ExecuteScalar + also works.</li> + + <li>Simple input parameters (character and numeric data) can now + be used in SQL queries. Output parameters do not yet work.</li> <li>OracleException and Error handling exists now.</li> + + <li>Message handling needs to be added for non-critical messages + received from Oracle</li> - <li>Handling of various data types need to be handled</li> + <li>Handling of various data types need to be added.</li> - <li>Data Adapter needs to be created. Tim has started on it.</li> + <li>Data Adapter exists, and a DataSet can be filled using it. The + Data Adapter is abstract enough that it should work as expected.</li> <li>Lots of missing functionality and bugs.</li> @@ -69,12 +78,12 @@ ** Action Plan <ul> - <li>Be able to retrieve results via a data reader</li> - <li>Parameters support</li> - <li>transactions</li> + <li>Be able to retrieve results via a data reader (WORKING)</li> + <li>Parameters support (IN PROGRESS)</li> + <li>transactions (WORKING)</li> <li>Stored Procedures, Functions, and Packages support</li> - <li>Be able to fill a DataTable in a DataSet via a data adapter</li> - <li>Support for Oracle 8i and 9i</li> + <li>Be able to fill a DataTable in a DataSet via a data adapter (IN PROGRESS)</li> + <li>Support for Oracle 8i and 9i (UNKNOWN)</li> <li>Support LOBs</li> <li>Support all the data types</li> <li>Implement Connection pooling</li> @@ -90,7 +99,7 @@ <li>Have access to an Oracle 8i database or download it from <a href="http://www.oracle.com/">Oracle</a>. If you are connecting remotely to an Oracle database, you need the Oracle client software. - Registration to the Oracle Technology Network is free. If installing on Linux, + Registration to the <a href="http://technet.oracle.com/">Oracle Technology Network</a> is free. If installing on Linux, I suggest you do a lot of searching to see how others installed Oracle on Linux.</li> <li>Make sure System.Data.OracleClient.dll assembly is built, if not, go @@ -114,33 +123,33 @@ public class Test { - public static void Main(string[] args) + public static void Main (string[] args) { string connectionString = "Data Source=testdb;" + "User ID=scott;" + "Password=tiger;"; IDbConnection dbcon; - dbcon = new OracleConnection(connectionString); - dbcon.Open(); - IDbCommand dbcmd = dbcon.CreateCommand(); + dbcon = new OracleConnection (connectionString); + dbcon.Open (); + IDbCommand dbcmd = dbcon.CreateCommand (); string sql = "SELECT ename, job FROM scott.emp"; dbcmd.CommandText = sql; - IDataReader reader = dbcmd.ExecuteReader(); - while(reader.Read()) { + IDataReader reader = dbcmd.ExecuteReader (); + while (reader.Read ()) { string employeeName = reader["ename"]; string job = reader["job"]; - Console.WriteLine("Employee Name: {0} Job: {1}", + Console.WriteLine ("Employee Name: {0} Job: {1}", employeeName, job); } // clean up - reader.Close(); + reader.Close (); reader = null; dbcmd.CommandText = sql; - dbcmd.ExecuteNonQuery(); - dbcmd.Dispose(); + dbcmd.ExecuteNonQuery (); + dbcmd.Dispose (); dbcmd = null; - dbcon.Close(); + dbcon.Close (); dbcon = null; } } |