Oracle Objects for OLE (OO4O) Release Notes

The latest OO4O patches and information is located at the following site:
http://otn.oracle.com/tech/windows/ole/

Release 9.2.0.4.4

April 2002

Copyright (C) Oracle Corporation 2002

This file contains important information specific to Oracle Objects for OLE release 4.4. The following topics are covered:

Install Notes: Oracle Objects for OLE, being a COM component, is NOT a MULTIPLE ORACLE HOME product. It should be installed only once, in ANY Oracle Home. Installing OO4O into a second home will render the previously installed OO4O version obsolete.

System Requirements

  1. Operating System: Windows NT 4.0, Windows 2000, Windows 98, or Windows XP.
  2. 32-bit application capable of OLE scripting (e.g. Visual Basic, Excel , etc.) or supported C++ compiler (Microsoft Visual C++ 6.x).
  3. Access to an Oracle8, Oracle8i or Oracle9i database through a local connection or a network using the Net client.  Oracle Net will need to be installed when accessing the Oracle database through a network.
  4. Required Support Files (RSF) 9.2.0 for OO4O.  The Oracle installer will ensure the RSFs are installed as part of the OO4O installation.
  5. A sufficiently high version of mfc42.dll (v. 6.00.x) to register oip9.dll. Registration should be done automatically by the Oracle installer.

If using the OO4O Code Wizard for Stored Procedures, Microsoft Visual Basic 6.0 needs to be installed on your machine before you can install the wizard. If VB 6 is not installed prior to the OO4O installation, either reinstall OO4O or simply run the regsvr32.exe utility from the command line as follows:
- regsvr32.exe oo4ocodewiz.dll
- regsvr32.exe odbtreeview.ocx
- regsvr32.exe oo4oaddin.dll
These files would are located in the ORACLE_HOME\bin directory.

General Information and Dependencies

This release is a 32-bit version of Oracle Objects for OLE.

What is included in this release:

Newest Features

For more information on these new features and objects, see the online help and example files.

Sample Files

Samples have been added to demonstrate usage of the C++ class libraries, thread safety features and for using OO4O within the Internet Information Server environment. The C++ examples can be found in \ORACLE_HOME\OO4O\CPP\WORKBOOK\ and the IIS samples can be found in the \ORACLE_HOME\OO4O\IIS\ directory. Visual basic samples can be found in the \ORACLE_HOME\OO4O\VB directory.
 

Getting Started

Please read the "Getting Started With the OO4O Automation Server" section provided in the online help and try out the sample programs installed with the product. Also, many methods in the online help include links to example code that you can cut and paste into your VB application and step through.

From Visual Basic 6, you can load the OO4O Type Library by going to the menu and choosing Project-->References. The name of the library is OIP9.TLB. After doing this you can browse the OO4O objects by going to the menu and choosing View-->Object Browser. The Data Control can be added by going to the menu and choosing Project-->Components. The name of the data control is ORADC.OCX.

ASP users can try out the sample located in the ORACLE_HOME\oo4o\Iis\Samples\ASP\ConnPool directory.
 

Building the C++ Sample Applications

Make sure that ORACLM32.LIB is listed on library list (under the "Link" tab). Make sure that ORACL.H and ORACLM32.LIB are on the path. Change the connect string and user name given in the sample if neccesary.

Installation Layout

As part of the OO4O installation, the following directories will be created and will contain the corresponding files:

Summary of problems fixed

1474160    UPDATING LONG RAW DATA MORE THAN 64K CAUSES AUTOMATION ERROR
2160551    GETROWS FAILS WITH AUTOMATION ERROR WHEN DYNASET HAS NO RECORD - SPECIFIC TO JA ENV
2163878    OCI-1861 HAPPENS IF USING ORAOBJECT OF DATETYPE OTHER THAN THE DEFAULT "DD-MON-YY"
1822373    OO4O CAN NOT HANDLE '9999/12/31 HH:MI:SS' DATE DATA
1938708    ORASQLSTMT.RECORDCOUNT RETURNS 0 IN ORASQL_NONBLK MODE
2153295    ODYNASET.GETFIELDORIGINALNAME FAILS TO RETURN DOUBLE QUOTED COLUMN NAME
1805186    MEMORY LEAK WHEN BIND PARAMETER DISABLED AFTER OSQLSTMT.REFRESH
2193777    DELETE METHOD FOR ORAREF DOES NOT WORK
2229314    MEMORY LEAK WHEN UPDATE DATA USING DYNASET IN A LOOP
2253122    AUTOMATION ERROR ON CREATEDYNASET WHEN DATABASE_NAME PARAM IS OVER 128 BYTE
2245154    CPP: OOBJECT.GETCOUNT() RETURN 0 FOR OBJECT COLUMN TYPE INSTEAD OF NUMBER OF ELEMENTS
1361495    CPP: MEMORY LEAK WITH GETFIELDNAME

Problems Fixed in release 4.3

1997123    MEMORY LEAK WHEN GET LONGRAW DATA WITH FOR LOOP USING OO4O AND VC++.
2003795    OO4O RUNNING ASP WITH IIS EXPERIENCES SLOW PERFORMANCE AND CPU USAGE ON Win2000
2103597    NLS: OO4O CODE WIZARD ADDIN DOES NOT PROPERLY DISPLAY JAPANESE PACKAGE NAME
1990136    -2147417848 METHOD 'CREATEPLSQLDYNASET' OF OBJECT '_IORADATABASE' FAILED
1973130    ACCESS VIO / OBJECT DISCONNECTED AFTER IDLING AFTER FREEING OBJECT / REF / COLL
1961911    OIP-16389 OCCURS WITH STRING THAT IS SMALLER THAN 128
2010082    MEMORY LEAK WHEN GETXML OR GETXMLTOFILE CALLED
2010122    MEMORY LEAK WHEN ORACOLLECTION IS CREATED
1969088    ORAFIELD.XMLTAGNAME = "" (NULL) DOES NOT CAUSE TAG TO BE OMITTED
1969094    ORAFIELD.XMLTAGNAME IGNORED WHEN XMLUPPERCASE IS TRUE
1969099    BAD XML STRINGS PASSED TO ROWSET, ROW, ROWID OR COLLID NOT CONVERTED

Problems Fixed in release 4.2

1909345    ERRORNUMBER RETURNS 0 WHEN GETDATABASEFROMPOOL FAILED TO OPEN DB
1913543    CANNOT GET ERROR INFO USING CONNECTION POOLING
1892152    COPYTOCLIPBOARD FAILS WHEN VARCHAR2 COLUMN CONTAINS ALL SPACES
1887601    OIP-4109 WHEN RUNNING MULTIPLE OO4O APPLICATIONS ON THE SAME MACHINE
1189812    ORADB_DEFERRED AND ORADB_NONBLK HAVE THE SAME VALUE
816219      ORADB_NO_REFETCH ALTERED TO ORADB_DBDEFAULT
805407      MEMORY LEAK WHEN USING ORIGINALNAME METHOD
671622      OO4O AND EXCEL97 CAUSES AN APPLICATION ERROR WHEN RETRIEVING DATE LIKE 12120098

Problems Fixed in release 3.14

1834597    MEMORY LEAK WITH TEMPORARY LOB OR WHEN USING A LOB AS A PARAMETER
1783743    CPP: ODATABASE.DESCRIBE() ACCESS VIO INSTEAD OF RETURNING ORA-4043 ERROR
1766430    GETNAME AND GETSTATUS RETURN BAD OR INVALID POINTERS
1878734    MEMORY LEAK WHEN EXECUTING BAD SQL WITH CREATEPLSQLDYNASET
1811093    MEMORY LEAK IF YOU REUSE BUFFER FOR BLOB WRITE
912623      MULTIBYTE ONLY: OIP-4121 WHEN USE BOOKMARK CREATED FOR HIGH ROW NUMBER
<none>      CPP: FIX FOR TEMP BLOB NOT BEING ABLE TO BE CREATED
<none>      NO SUPPORT AGAINST UTF8 DATABASES

Problems Fixed in release 3.13

<none>      ORADC:  DATACONTROL DOES NOT RESPOND TO DOUBLE CLICKS
1410726    OO4O C++ LEAKS MEMORY WHEN REFRESHING DYNASET WITH NEW SQLSTATMENT
1531083    SECOND OPEN USING AN OPS$ LOGIN CRASHES IN OIP8.DLL
1729234    OO4O RETURNS THE WRONG LONG DATA OVER 64K
1539421    CANNOT CATCH ORA-1555 ERROR USING "ON ERROR GOTO" STATEMENT
1493342    WARNING ORA-28011 TREATED AS ERROR; WARNING ORA-28002 IN LASTSERVERERR
1471037    ORASESSION.LASTSEVERERR RETURNS ORA-28001 INSTEAD OF ORA-28007 ON CHANGEPASSWORD
1388339    ORA-6502 RETURNED EXECUTING PL/SQL BLOCK (MINIMUMSIZE PROPERTY IGNORED FOR BOTH)

Problems Fixed in release 3.12

1403496 - METHOD GETROWS DETECTS ONLY HALF OF MULTI-BYTE DATA
1509544 - ORADYNASET NOT UPDATABLE WHEN THERE IS AN EXTRA BLANK

Problems Fixed in release 3.11

1478272 - ORA-24347 WARNING TREATED AS ERROR
1418974 - GETROWS CRASHES WHEN DATA INCLUDES EMPTY STRING
1415566 - DATACONTROLS THAT ARE SHARING CONNECTIONS ROLLBACK WHEN CLOSED
1411252 - CPP: APARTMENT THREADED APPL NOT SHARING CONNECTIONS AS IN 2.3
1380950 - ORAPARAMETER CAUSES MEMORY LEAK
1370046 - LASTSERVERERR CONTAINS 1403 AFTER ORADYNASET.ADDNEW / UPDATE
1364379 - DYNASET NOT UPDATABLE WHEN TABLE NAME CONTAINS "FROM"
1364313 - DYNASET UPDATE FAILS WHEN TABLE NAME ENCLOSED IN QUOTES
1353095 - MULTIBYTE - ORACLOB.READ  TRUNCATES THE CLOB DATA
1344141 - MULTIBYTE - RUNTIME ERROR WITH CLOB.COPYTOFILE
1344085 - MULTIBYTE - TRUNCATED DATA WITH CLOB.COPYTOFILE
1340481 - CAN NOT INPUT THE NULL VALUE TO THE ORACLE DB IN USE OF ORAPARAMARRAY.
1314101 - MEMORY LEAK IN ORADYNASET.EDIT METHOD
1017692 - TRIM METHOD ON VARRAY TRIMS ONE  LESS THEN REQUESTED
961176 -  CREATEAQ METHOD DOES NOT RETURN AN ERROR IF IT FAILS
955239 - LASTSERVERERROR, ERROR$ WRONG IF CREATEDATABASEPOOL FAILS
953358 - MULTIBYTE - ORA-24812 WITH ORACLOB.READ
<none> - ACCESS VIOLATION WHEN USING COLLECTION ITERATORS
<none> - ORACOLLECTION - WHEN DYNASET MOVED, EOC BOC NOT RESET
<none> - ORACOLLECTION ELEMENTS CANNOT BE SET TO NULL
<none> - CPP: APT THREADING - TRANSACTIONAL METHODS ON OSESSION MAY BE IGNORED