X-Git-Url: http://wien.tomnetworks.com/gitweb/?a=blobdiff_plain;f=web%2Foracle;h=a83eb776c35025d9349de80518fcf6768d50159c;hb=50beb484c091b7eb9fdd4cba436757c12f316b8d;hp=16188b522ab7e4c6570594a2b055be04bc0b6ee6;hpb=3570fe498f7ebabafe6baf6e26e2a035d1df0d54;p=mono.git
diff --git a/web/oracle b/web/oracle
index 16188b522ab..a83eb776c35 100755
--- a/web/oracle
+++ b/web/oracle
@@ -8,9 +8,7 @@
Works on Windows and Linux
- Works with Oracle 8i
-
- May work with Oracle 9i
+ Works with Oracle 8i and 9i.
Uses the Oracle CLI (Call Level Interface) which is a C library (API) for the Oracle Client
software
@@ -30,23 +28,15 @@
** Current Status
- - OracleConnection can connect and disconnect to an Oracle 8i database on
+
- OracleConnection can connect and disconnect to an Oracle 8i or 9i database on
Windows and Linux via OCI (Oracle Call-level Interface)
- - No longer uses a glue library (a library between the System.Data.OracleClient.dll
- assembly and the oci library). In Current Mono cvs, System.Data.OracleClient
- directly platform invokes into the oci library thanks to Tim Coleman.
-
- Can have multiple connections with different transactions where each transaction is
separated from the others, so a rollback or commit in one transaction
does not affect the other.
- Can execute simple DML SQL statements, such as,
INSERT a row into the EMP table via the OracleCommand's ExecuteNonQuery method
-
- - The System.Data.OracleClient.dll assembly can be built with mcs/mono via
- the makefile.gnu for System.Data.OracleClient or csc/.net via the
- System.Data.OracleClient.build nant build file.
- Can retrieve data via ExecuteReader and OracleDataReader. Currently,
supports character, numeric, some date data types. ExecuteScalar
@@ -66,8 +56,7 @@
- Lots of missing functionality and bugs.
- - Works with SQL# command-line and GTK# versions in cvs. Only works with
- simple character data though.
+ - Works with SQL# command-line and GTK# GUI versions.
@@ -79,9 +68,11 @@
transactions (WORKING)
Stored Procedures, Functions, and Packages support
Be able to fill a DataTable in a DataSet via a data adapter (IN PROGRESS)
- Support for Oracle 8i (WORKING
- Support for Oracle 9i (UNKNOWN)
- Support LOBs
+ Support for Oracle 8i on Linux and Windows (WORKING)
+ Support for Oracle 9i on Linux and Windows (WORKING)
+ Support for Oracle 10g on Linux and Windows [TODO]. Please let us
+ know on mono-list if Mono OracleClient works with Oracle 10g or not. If not, what errors do you get
+ Support Large OBjects
Support all the data types
Implement Connection pooling
Security
@@ -99,9 +90,7 @@
Registration to the Oracle Technology Network is free. If installing on Linux,
I suggest you do a lot of searching to see how others installed Oracle on Linux.
- Make sure System.Data.OracleClient.dll assembly is built, if not, go
- into System.Data.OracleClient and do a make -f makefile.gnu (on Linux) or
- ../../nant/NAnt.exe (on Windows using Cygwin).
+ Make sure System.Data.OracleClient.dll assembly is built.
Take a look at TestOracleClient.cs found at mcs/class/System.Data.OracleClient/Test
@@ -161,12 +150,10 @@
-r System.Data.OracleClient.dll
- Build on Windows via Cygwin:
+ Build on Windows:
- mono C:/cygwin/home/MyHome/mono/install/bin/mcs.exe \
- TestExample.cs \
- -lib:C:/cygwin/home/MyHome/mono/install/lib \
- -r System.Data.dll -r System.Data.OracleClient.dll
+ mcs TestExample.cs /r:System.Data.dll \
+ /r:System.Data.OracleClient.dll