Version History

Apollo Pro was initially released in October of 1998 as version 1.0. This first version used an odbc connection and allowed the user to type in a single sql statement and view the results in a grid. Lightyears ahead of SQL*Plus if you wanted to browse your data for analysis. Since that time, it has under gone a lot of enhancements, and of course, it's share of bug fixes. You will find listed below the features added and bugs fixed for versions above 2.0.

Version 3.0.5, released Tuesday, December 9, 2008
- Enhancements:
  - Removed registration routine.

Version 3.0.3, released Tuesday, April 24, 2007
- Bug Fixes:
  - If the database and client PC had conflicting decimal separators, the user would get an error “2.05 is not a valid floating point number”, and the unit test would not run.

Version 3.0.2, released Thursday, January 11, 2007
- Enahncements:
  - Allow entry of mixed case passwords.

Version 3.0.1, released Tuesday, December 05, 2006
- Bug Fixes:
  - In an Oracle 10.2 database, the database tab was no longer sorting by schema
  - When dragging multiple items from the database tab onto the editor, the items would come out in an unpredictable order
  - PL/Unit tests will now retry execution if an ORA-04061 error is received due to recompilation of a package

Version 3.0, released Sunday, November 12, 2006
- Enhancements:
  - First freeware release
  - Addition of a set of standard templates shipped with the product. Located in the Program Files/Apollo Pro/Templates directory.
  - Ability to assign a key sequence shortcut to a template. Right click any template, and choose Create Shortcut. Type any text and save. Activate the shortcut by typing the shortcut text followed by ctrl-space.
  - Code complete added to schemas. Type a schema name followed by period, and code complete will popup with all schema objects in it.
  - Drag and drop multiple columns or tables from database tab onto editor

Version 2.5.4, released Thursday, February 16, 2006
- Enhancements:
  - Type source is shown on popup describe
- Bug Fixes:
  - Case sensitive package names would not show subprocedures in DB Navigator
  - Dropping a file from Windows Explorer would not open the file in the SQL window to which it was dragged.
  - Show errors command after create or replace type body did not work

Version 2.5.3, released Monday, February 13, 2006
- Enhancements:
  - Disconnect menu option added to SQL menu in SQL Window
  - Substitution variables work for the connect and exec commands
  - Menu item added to the popup menu of the database grid to clear grid contents
  - Menu items added to the popup of the SQL editor to clear the editor contents
- Bugs Fixes:
  - Fixed problem where code complete window might popup when typing a dot in front of an object name
  - Case sensitive objects will show code complete
  - Minor fix to autocomplete
  - Improved screen handling of column mode typing
  - In FTP client, if answering Yes To All on an overwrite, it will no longer stay in effect for the duration of the FTP session
  - Parameter hints would not show for procedures in the DB Navigator
  - Code hint will show reliably when pressing the ( key
  - Pasting text containing unix style end of line characters will format correctly in the editor
  - Improved tab drag and drop when dragging a tab to the last position
  - Dragging an object from the DB Navigator onto the editor could have caused an Index Out Of Bounds error

Version 2.5.1, released Saturday, February 11, 2006
- Enhancements:
  - Tabs are moveable in the SQL window.
  - Opening a script that contains @@ commands and running it will use the directory from which the script was loaded to search for the @@ scripts.
- Bug Fixes:
  - Error loading meta.dat under certain circumstances

Version 2.5, released Friday, February 10, 2006
- Enhancements:
  - Only allow one SQL History window to be displayed.
  - Automatically set the file extension appropriate to the format chosen when exporting the data grid.
  - Data grid popup menu has options to export grid data, print grid, get all rows.
  - User can view source code for types
  - Sid and Serial# for session is displayed in the SQL Window, in the drop down list that also displays the server version.
  - In column mode typing, the topmost selected line is the second most visible line. Applies for indent and unindent also, allowing the user to see how far to indent/unindent.
  - Generated export code is opened into an editor page after saving to the file system.
  - Window flicker was eliminated on opening a new SQL Window when another is already maximized.
  - Support for stored objects created with quotes added to the database navigator.
  - Tabs will be replaced with spaces automatically in the editor pages when typing, viewing source, opening a file, or pasting from the clipboard..
  - It is now possible to drag and drop multiple columns form the database navigator tab onto the editor.
  - Added Java Classes to the Database Navigator.
  - Added support for CREATE JAVA, ALTER JAVA, DROP JAVA statement.
- Bug Fixes:
  - PL/Unit rerun button would not work if package was created with double quotes around the name.
  - Nested PL/Unit suites could have appeared incorrectly in the display if nested more than 5 deep.
  - Running a PL/Unit test with a very large amount of DBMS_OUTPUT calls would cause the application to become unstable.
  - In some instances, a failing teardown would have appeared to be successful.
  - Case sensitive pl/sql objects would not show errors appropriately with the show errors command.
  - Order by clause not working in data tab of popup describe if where clause was also not specified.

Version 2.4.1, released Thursday, August 11, 2005
- Bug Fixes:
  - Countries where the decimal separator was not the period could not use Apollo Pro due to invalid floating point number error during the registration routine.
  - PL/Unit would not compile on anything less than Oracle 10g, due to wrapping.

Version 2.4, released Tuesday, July 26, 2005
- Enhancements:
  - Added PL/Unit, a PL/SQL unit test framework and test runner
  - Now support multiple files in single window with a tabbed interface
  - When viewing source of a package and no package body is available, a comment will be inserted indicating that fact
  - Added auto completion of certain pairs of characters: ' ', ” ”, ( ), and [ ]. The functionality is controlled by the Auto Character Insertion option, and defaults to on.
  - Added a refresh button to Database Navigator tab
  - Added Code Complete showing columns for tables, views, and materialized views when typing a period after object name. Delay is controlled by an option setting.
  - When viewing the source of a package, procedure, function, or trigger, the text CREATE OR REPLACE will be appended to the beginning of the source definition
  - Popup describe for database objects enhanced
  - Find and replace dialogs will be initialized with selected text for the find text
  - The SQL-99 WITH clause syntax for select statements is now a supported statement
  - Added support for FLASHBACK statement
  - Added a tab that shows v$session_longops information, along with session statistics
- Bug Fixes:
  - When dropping a template that contained a concatenation operator (||), the first bar of the operator was removed and used as the cursor locator
  - Causes invalid character error: select * from all_objects where object_name like '”%';
  - Opening a file from windows explorer when Apollo Pro is not running results in an error, and file is not opened.
  - Table describes are producing very long columns on 9.2.0.4 on Windows 2000 Server.
  - There is a bug in the SQL window, when the grid panel is not visible, and the error message panel is unchecked using the View menu, the grid panel will not resize.
  - Mouse wheel causes problems with highlighting in the grid output
  - If a LOB field is the only selected column from a table, and only one row is returned, the popup window would not activate when clicking the cell
  - Generated encapsulation functions for merge, insert, update, and delete were returning incorrect number of rows.
  - Generated encapsulation function and procedure for merge had incorrect syntax
  - In column selection mode, backspace key does not work. Some enhancements also made to column mode typing

Version 2.3.1, released Thursday, July 15, 2004
- Enhancements:
  - Added a Yes To All button when the FTP client asks whether to overwrite remote files.
  - Added confirmation of download to double-clicking on a file on the remote site.
- Bug Fixes:
  - If Apollo Pro was not started in the default directory, then the user would see an error stating grammar not loaded when running some SQL*Plus commands.
  - If running a script that has multiple connect commands in it, the application may have locked up.

Version 2.3, released Monday, July 12, 2004
- Enhancements:
  - Placing a vertical bar in a template will cause the cursor to be positioned there when using the template.
  - Popup describe (Ctrl-D in SQL Editor) now supports more objects.
  - Added support for as sysdba/sysoper option in connect command.
  - Added a popup menu item to the Database Tab in the SQL window to allow viewing source of views, materialized views, packages, procedures, functions, and triggers.
  - Added a Most Recently Used Logon List to File|New.
  - Added Most Recently Used File menu.
  - Moved Edit menu item from Wizard Menu, it is now handled by File|Open.
  - Support for object types in select statements added. Object types are flattened in the grid display.
  - Added a code generator to create a table encapsulation package. Accessible by right clicking on the table in the Database Tab in the SQL window.
  - Added a draggable window that shows the errors for any errors that occur during execution. Clicking on an item positions the cursor at the error location. Right click for a context menu that allows copying the error to the clipboard.
  - Support for the Oracle 10g Client added.
- Bug Fixes:
  - If a column in the grid was larger than the width of the grid, it could not be resized. Columns will now never be larger than the width of the grid.
  - Conflict between shortcut for Execute At Cursor and recalling a bookmark. The shortcut for Execute at Cursor was changed to F5.
  - Access Violation could be received when closing SQL window in some cases.
  - Shut Off Secured Features Menu item was not clearing out the logon list.
  - Closing SQL window while the Database Tab was being populated caused the application to hang.

Version 2.2, released Tuesday, January 27, 2004
- Enhancements:
  - Added Select All menu item and Ctrl-A capabilities to the SQL History window
  - When indenting(Ctrl-I), unindenting(Ctrl-U), commenting(Ctrl-Del), or uncommenting(Ctrl-Ins) a long line of code, the cursor will now remain in view.
  - Added an option to prevent a session from being saved to the logon list
  - Add change connection option for current SQL window.
  - Allow user to cancel Get All Rows and Export Grid operations.
  - Added Edit button in SQL history to open SQL window
  - Added option to control whether the duplicate session button copies editor contents
  - Pressing enter in the previous sessions list will open the window with the selected username
  - Confirmation on clearing SQL history
  - The user is now given three chances to enter the secure password before opening Apollo Pro
  - Support multiple paths for templates, wizards, and SQL files
  - Added find capability to SQL History
  - When opening an SQL window from the SQL History window and the user has security enabled and has saved the logon list, then the password will be looked up in the saved list and used if available.
  - Added an FTP client
  - Enhance popup describe to support more objects
  - Secured Features can now be shut on and off after Apollo Pro has been started.
  - Apollo Pro can be set to auto lock after a specified period of inactivity. Use the Security Lockout Time option to set this value in minutes.
  - Added block selection mode to editor. Hold down alt key while selecting with the mouse or keyboard
  - Add an SQL folder to the template and wizard browser
  - Added a tab to view text of views, materialized views in DB Navigator. Also shows PL/SQL for procedures functions, and packages.
  - Refresh the contents of the Files browser in the SQL window when a file change is made to the underlying directories
  - DB Navigator extended to show information on more objects, including materialized views, procedures, packages, functions, types, sequences, and built-in functions
  - Enhance describe command to work on packages, procedures, and functions.
  - Add ability to SQL window to open file from FTP and save to FTP
  - Added support for new 9i MERGE statement
  - Allow connection as sysdba or as sysoper. Required to logon as SYS.
  - When dragging and dropping, the caret will now follow the cursor
  - Database object tab added to SQL window showing tables, views, materialized views, functions, packages, procedures, types, and sequences.
  - Added Workspace object to SQL window. Used to organize projects by grouping database objects, and files in one place.
- Bug Fixes:
  - Cut, copy, paste and export btn/menu items are enabled during a grid operation
  - Accept command with no prompt specified would not show the default prompt.
  - On commits and rollbacks, the popup window appears before the command is complete.
  - When SQL window is restored from max state and editor is shrunk, the toolbar disappears
  - Error highlighting not working correctly when error is inside a script
  - Get All Rows does not show progress on status bar
  - Creating a stored package, procedure or function with the schema specified in the object name caused show errors to be unable to show any errors
  - || should be a delimiter when highlighting an error
  - Resizing the grid when executing the Get All Rows feature would cause inconsistent errors.
  - An extra delimiter was being added to the end of each line when exporting as tab or other-delimited
  - Popup describe does not grab entire object descriptor (I.e. schemaname, etc.)
  - Popup Describe is changing the cursor position in the editor
  - If the SQLHistory.* files were not available, due to permission problems for instance, then an error would be shown for every query run from the SQL window.
  - Select * from dba_constraints to text output gives an error (field search_condition is a long, cannot convert to string)
  - When exporting, and a column grid has been moved, the column title is not moved in the export, but the data is.
  - Read only files would open with bad highlighting
  - When closing a read-only file, the editor remains read-only
  - CREATE TYPE BODY was not supported
  - % should be a delimiter when parsing for substitution vars
  - Compiling a type or type body did not show a feedback message of success or failure.
  - Long columns were not fetched to the text output properly, causing an error “Unable to convert field <name> to string.”
  - Clobs and Blobs would not display in the popup display window
  - Record counter not resetting when a query returns no rows
  - Cannot show execution plan for delete or update statements
  - BLOB's and CLOB's cause an error message to appear stating you need OCI8 mode

Version 2.1, released Friday, September 6, 2002
- Enhancements:
  - An SQL Editor window was added.
  - A Goto command was added to the edit menu of the SQL Window and SQL Editor.
  - Files can be dragged and dropped onto Apollo Pro, opening the SQL Editor.
  - Current Line and Column is now shown on the status bar of the SQL Editor.
  - The current Oracle session may be cloned to a new window in the SQL Window.
  - Block indenting and unindenting was added to the SQL Editor.
  - Block Commenting and uncommenting was added to the SQL Editor.
  - Options to uppercase and lowercase the selected text in the SQL editor were added to the Edit menu.
  - Support was added for SQL*Plus style CONNECT command in the SQL Editor.
  - It is now possible to associate files to Apollo Pro, opening the SQL Editor by double clicking on a file.
  - A Template and Wizard browser has been added to the SQL Window, along with a Wizard editor.
- Bug Fixes:
  - Running a script in the SQL Window using the @ or @@ command with spaces before the @ results in “file not found” error.
  - Hints were not being added correctly to the tuned SQL in the Power Tune window.
  - A comment located before an SQL statement containing a single quote (single or double) would cause an ORA-00911: Invalid Character error.
  - In some cases, showing the execution plan from the SQL Window or the Power Tune window would cause an ORA-00933: SQL command not properly ended.
  - A statement containing a comment on the line that contains the terminating semicolon would have caused the statement terminator to be missed.

Index

Version History