2003-02-19 Tim Coleman <tim@timcoleman.com>

	* oracle: update oracle status page

svn path=/trunk/mono/; revision=11731

1 files changed, 30 insertions, 21 deletions

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;
     }
  }