Direct Oracle Access - News

• Support for the ODAC Instant Client added
• Support for merge, with, purge and flashback commands added to TOracleScript
• TOracleScript performance improvement for large commands
• Setting the same UTF16 variable twice could lead to extra characters

• Win32 only, no support yet for .NET and C#.
• There is no integrated help. The help file is provided in the old format.

• Kylix 2 compatibility
• C++Builder 6 compatibility
• Added additional support for ConnectAs in logon history

 Bugfixes

• Message translation did not work if parentheses were present in the original message text
• Thread handle was not correctly closed for Threaded TOracleQuery
• Query with XMLType column would crash (unsupported by OCI)
• Apply updates not committed after requerying a record changed by another user
• TOracleDataSet.ExecuteQBE would Rollback if LockingMode = lmLockImmediate
• Rowid's of Index Organized Tables are now fetched correctly
• OracleLogon ConnectAs is now hidden when ForceOCI7 = True
• Fixed OCI-22060 error when accessing attributes from embedded objects obtained by ObjAttr()
• Fixed problem refreshing objects that contain collections
• Byte parameters did not work in TOraclePackage in Delphi 6
• OracleDataSet.SearchRecord did not post record
• TClientDataSet.CommandText did not support CLOB and BLOB parameters
• Improved diagnostics on Linux when loading Net8 fails
• Writing null CLOB's and BLOB's through a TDataSetProvider could lead to "Pass LongInt(Object) to complex variable" exception

• Delphi 6 compatibility
• Query Builder 1.0.1 released with drag & drop support for synonyms

 Bugfixes

• Explore item was missing from TOracleDataSet popup menu
• Setting TOracleDataSet.Master at design time could cause Access Violation
• Design time confirmation dialogs could display incorrect button titles
• Decreasing the array size to 1 for subsequent Array DML statements could cause errors on Net8

• Kylix compatibility
• Design-time Query Builder added
• Holding down Ctrl key during logon dialog prevents logon history

 Bugfixes

• DirectPathLoader.Destroy could cause an AV when called after session was logged of
• TOracleScript fixes:
  • A command would still be executed when handled in OnCommand event
  • A */ (end comment) would sometimes be interpreted as / (end command)
  • An AV could occur if in an empty script an empty command was added
  • If multiple variables were declared with the same name, only the first would get used
• Provider Support fixes (Delphi 5 & C++Builder 5):
• TClientDataSet would always be reset to ptInput
• Descending items in order by clause did not work
• Upper(column) items in order by clause did not work
• Views owned by the current user could not be used
• TOracleDataSet.CommitProviderTransactions run-time property added
• Package Wizard did not like non-existing directories
• Nested Table and Varray parameters would not be handled correctly by Package Wizard
• TLOBLocator.Assign would lead to AV's when source is NULL
• Assigning NULL LOB to TOracleObject.LOBElements[Index] would lead to AV's
• Check constraints with partially matching column names would sometimes not be evaluated correctly (ORA-01036) for a TOracleDataSet with CachedUpdates
• Oracle Date/Time values that cannot be represented in Delphi's TDateTime converted to -693594 (invalid date, displayed as 00-00-0000)
• TOracleObject.CallMethod did not work on Net8 8.1.7 due to Net8 bug
• Tab key could not be used in SQL Property Editor
• SQL Property Editor displayed floating point numbers without precision as integer
• Posting an unchanged record with LockingMode = lmLockImmediate would leave the record locked
• TOracleSession.Share now copies the LogonUsername, LogonPassword and LogonDatabase properties from the source session
• TOracleDataSet.ExecuteQBE would cause an access violation for an inactive dataset
• TOracleSession.CheckConnection now also reconnects if Connected = False

• TOracleObject.LOBElements added
• TOracleObject.AddElement added
• TOracleQuery.DescribeFull added

 Bugfixes

• Foreign key checks with more than 1 column could sometimes fail
• OracleCI.OracleHomeName always returned last oracle home name
• TOracleDataSet provider support: PSExecuteStatement did not support result set
• TOracleDataSet provider support: default order did not work for prefixed columns in order by clause
• Package Wizard would always declare PL/SQL Tables of type otString
• TPLSQLTable with table size 0 would lead to exception
• TDirectPathLoader columns editor included unsupported packed decimal datatype
• TDirectPathLoader.GetDefaultColumns now places LONG, LONG RAW, CLOB and BLOB at the end
• Calling TOracleDataSet.Free for an active dataset could lead to errors
• TOracleObject.Assign would not copy elements for collection objects
• TOracleLogon.HistoryRegSection would not work if first character was a \
• Fixed memory leak for TOracleDataSet connected to a TDataSetProvider
• RefreshAllFields and QBE did not work if SQL contained comment in quotes (e.g. '--')
• In Delphi 5 / C++Builder 5, when simultaneously inserting a master & detail record, the detail record would be posted before the master record
• TOracleObject did not support mixed case attribute and method names
• TOracleScript could not handle non-SQL commands terminated with a semicolon
• TOracleDataSet would not restore TField.ReadOnly & TField.Required properties after QBE mode, if these property values were set at run-time
• Compound foreign key constraints were incorrectly checked if one or more columns were null when TOracleDataSet.Dictionary.EnforceConstraints = True
• Package Wizard did not deal with (* or *) in Package Specification
• Package Wizard would generate incorrect type names for %RowType parameters

• Net8 8.0.3 and 8.0.4 would be forced to OCI7 mode
• Added ExtProcDetected boolean to OracleCI, indicating External Procedure Support
• Appropriate exception raised when TOracleSessin.ExtProcShare is called on Net8 8.0.3 or 8.0.5 (not supported)
• On SQL*Net a Logon error would result in a hang-up after a second attempt
• TOracleScript would not correctly handle PL/SQL Blocks that start with DECLARE
• TOracleScript would not recognize ANALYZE statements
• TOracleScript.CommandByName now returns a TOracleCommand (instead of an index)
• Primary Oracle Home detection could fail for homes with partially matching directories
• For CachedUpdates, inserting Master + Details required Detail refresh (missing records)
• Creating collection objects with TOracleObject.Create would lead to OCI-21560
• When using OracleMonitor in DLL and Main application, it would hang on exit
• Calling OracleDataSet.ExecSQL would not be displayed correctly in Oracle Monitor

• Shared sessions would lead to Access Violation during logoff on SQL*Net 2
• Package Wizard ignored 'Always use Variants' option
• Package Wizard failed on multi-byte character set database (ORA-01026)
• OracleMonitor unit would hang on termination when used in DLL or OCX
• Removed SyncObjs unit conflict with INETxx package
• Delphi 3, 4 and C++Builder 3 required Professional edition

• Oracle Monitor utility added
• Package Wizard added
• TOracleScript component added
• TOracleDirectPathLoader component added
• Support for Oracle Services for MTS added
• Support for External Procedures added (TOracleSession.ExtProcShare, OCIDate..., OCINumber...)
• Design time preferences added (OCI DLL, Oracle Home, Logon, EOracleWarning)
• Oracle menu added in IDE (wizard, apps, preferences, docs & info)
• Package names changed to doa34[D|C][3|4|5] (e.g. doa34d5 for Delphi 5)
• New installer gives more control over destination directories and palette

 TOracleSession enhancements

• Preferences.NullLOBIsEmpty property added
• ConnectAs property added

 TOracleLogon enhancements

• Caption property added
• HistoryIniFile property added
• Option ldConnectAs added, and ltConnectAs string constant
• DoBeforeLogon and DoAfterLogon protected procedures added (for derived classes that need to notify logon changes)

 TOracleQuery enhancements

• Added overloaded Set & GetVariable functions with Index

 TOracleDataSet enhancements

• OracleDictionary.RequiredFields property added
• GetUpdatingTable function is now virtual
• DetailFields no longer required for master/detail relation
• Field datatype ftOraClob and ftOraBlob supported for Delphi/C++Builder 5
• Added overloaded Set & GetVariable functions with Index

 TOracleDataSet QBE enhancements

• QBEModified property added
• ClearQBE method added
• AutoContains option added
• QBEMode Font & Background colors added
• Runtime QBEDefinition access enabled and documented

 TOracleEvent enhancements

• InternalSession property added
• KeepConnection property added
• LogOff procedare added

 TLOBLocator enhancements

• AsString property added

 Delphi/C++Builder 5 Provider Support improvements

• Params from TClientDataSet are now copied to TOracleDataSet
• Fixed 'UpdatingTable required' error message for cursor datasets

 OracleCI unit enhancements

• Function TNSNames returns tnsnames.ora filename
• Function OracleAliasList returns database aliases
• Function OracleHomeList returns list of oracle homes

 Component Editor improvements

• Logon dialog(s) now use logon history
• Settings stored in registry under Software\Allround Automations\DOA
• Shortcut keys for OK & Exit buttons added in SQL Editor
• Variables Editor can now remove variables when Scan SQL button is pressed

• Support for Net8 8.1.x (Oracle8i)
• Support for Multiple Oracle Homes
• Improved SQL*Net/Net8 problem diagnostics

 TOracleSession

• Design-time only connection
• MessageTable for error message translation
• Preferences (FloatPrecision, IntegerPrecision, SmallIntPrecision, ConvertCRLF, UseOCI7, TrimStringFields)
• Check and re-establish database connection
• RollbackOnDisconnect property

 TOracleQuery

• Substitution variables
• PLSQLString (32K) and Char variables
• StringFieldsOnly: define all fields as strings
• Overloading for Field functions in Delphi 4 and C++Builder 4
• Cancel procedure
• Threaded mode: run any query in a background thread
• RowCount function

 TLOBLocator

• LoadFromFile
• SaveToFile

 TOracleDataSet

• Local filtering
• RefreshOptions (BeforeEdit, AfterInsert, AfterUpdate, AllFields)
• OracleDictionary: specify usage of dictionary information (Constraints, UseMessageTable, FieldKinds, DefaultValues, DisplayFormats, RangeValues)
• New functions to support the OnApplyRecord event
• Support for views with "instead of" triggers
• CountQueryHits: count records before fetching them
• Design-time only activation
• CloseAll: close all cursors associated with the dataset
• String constants for translation of standard messages
• New variable types and StringFieldsOnly property from TOracleQuery
• New AfterFetchRecord event to limit query results, display progress information, and so on
• New SearchRecord function to search records in an active dataset

 Property Editors

• SQL Editor and Database Explorer fonts can be customized and can be printed
• Executing a SQL statement in the SQL Editor is now performed in a background thread, allowing you to break execution

• Query By Example (QBE) mode added in TOracleDataSet
• TOracleNavigator component added to support QBE mode
• Added support for standard Oracle packages in TOracleSession
• TOracleEvent.Synchronized added
• Added the ability to use the RowId as a field in TOracleDataSet.Locate
• Some bugfixes

• New TOracleProvider component to support multi-tiered applications
• New TOracleEvent component to handle dbms_alert signals and dbms_pipe messages
• PL/SQL Table support added
• TOracleDataSet.CachedUpdates added
• TOracleDataSet.OnApplyRecord event added to overrule default DML
• TOracleDataSet.SequenceField added to support Oracle Sequences
• Optimized TOracleDataSet.EnforceConstraints with a caching mechanism
• TOracleDataSet.GetUpdatingTable added
• VariableCount, VariableName, VariableType added to iterate variables
• TOracleLogon translation possibility added
• TOracleLogon.Options extended with ldDatabaseList (enables list with aliases)
• TOracleSession.ServerVersion added
• TOracleSession.Cursor added
• TOracleSession.InTransaction added
• Removed requirement that ORACLE_HOME\bin must be in PATH

• Native support for Oracle8, allowing you to use:
  - BLOB, CLOB and BFile data types
  - Oracle Objects
  - Password expiration
• Personal Oracle Lite support
• Component editors added (Explorer, SQL Editor)
• Set password dialog added (TOracleLogon.SetPassword)
• Multiple Longs/LOB's per dataset
• TOracleQuery.FieldAs... added to be able to avoid variant fields
• TOracleSession.OnChange event added
• TOracleSession.BeforeLogOn and AfterLogOn event added
• TOraclePackage.PackageName can be empty to access functions/procedures
• TOracleDataSet.RefreshRecord added
• TOracleDataSet.Locate improved
• Some bugfixes

• Array variables introduced to support Array DML
• Cursor variable introduced for TOracleQuery and TOracleDataSet
• TOracleSession.BreakExecution added
• TOracleDataSet.CommitOnPost added
• TOracleQuery.FieldScale & FieldPrecision added
• ErrorLine and ErrorPosition added to TOracleQuery & TOracleDataSet
• SQL*Net 1 support added
• Improved diagnostics for SQL*Net initialization
• Some (minor) bugfixes

• TOraclePackage component added
• TOracleSession.ThreadSafe property added
• Compatibility with Oracle8
• TOracleDataSet.RefreshMode property added
• Easier and faster support for Long and Long Raws
• BeforeQuery & AfterQuery events for TOracleDataSet & TOracleQuery
• TOracleSession.ExternalLDA added
• Some bugfixes
• 
  
• User quotes added to the website

• Online help added
• TOracleDataSet.QueryAllRecords added
• Automatic Master/Detail configuration added
• TOracleDataSet.EnforceConstraints added
• Support for Long and Long Raw datatypes as BLOB
• TOracleDataSet.RowId added
• TOracleSession.ErrorMessage added
• Some bugfixes

• TOracleDataSet.LockingMode added
• TOracleDataSet optimized
• TOracleQuery.FieldIsNull added
• Locking bug in TOracleDataSet fixed (string set to null, post, edit again leads to 'Changed by other user')

• SUPPORT FOR DATA-AWARE COMPONENTS! (Delphi 3 Version only)
• TOracleQuery.FieldOptional added
• TOracleQuery.RowId added
• TOracleQuery.Describe added
• TOracleSession.Savepoint & RollbackToSavepoint added
• TOracleSession.SQLTrace, OptimizerGoal & IsolationLevel added
• TOracleSession.SetTransaction added
• Value added to Variables property editor

• Both Delphi 2 and 3 are supported now.
• Evaluation check improved.
• Username, Password and Database contain correct values after logon.
• Commandline parameter UserId=user/password@database added.
• Cursor restored after exception in a Query.
• TOracleLogon.Execute returns true if something changed.
• TOracleQuery.FieldIndex added.
• MLSLabel internal datatype corrected.
• Maximum length for errormessage increased to 2000

• TOracleQuery.Warningflags added to let you determine warnings after a query.
• SetVariable string to date conversion improved.
• Initialization of SQL*Net improved for NT 3.51
• Speed improvement for queries with large SQL statements.
• Logon dialog position now at screen center.
• TOracleQuery.Cursor property added (specifies the mouse cursor during the query).
• Little bug in TVariables property-editor fixed (deleting variables).