Piper: Version 3.38 New Features

24-Dec-2002 -- news_V338

WARNING.. SQL*Plus support is ONLY for Oracle client-side releases 9.0 or higher! We use SQL*Plus's latest HTML support features and they are unrecognised in 8.1.7 or older clients!
Piper can now pass commands directly to SQL*Plus. This can be useful in many cases. You must have SQL*Plus installed on your workstation. Just prefix your command with 'plus' or 'sqlplus' or '+'. A SQL*Plus session will be opened and maintained for you for the duration of the current connection. Output will appear in Piper's HTML Browser Window. Any HTML formatting here is done by the SQL*Plus HTML output support feature. REMEMBER that for SQL*Plus to actually run a simple SQL Statement, you should suffix it with a semi-colon, also in this and other cases the 'run' command or just a slash on a line by itself will cause the contents of the SQL Buffer to be executed.
New toolbar buttons are available to force Piper's default SQL statement execution into using SQl*Plus versus using Piper's usual mode.
A new menu option 'View->SQL*Plus settings' is available which lets you set the starting directory for SQL*Plus sessions, and lets you set an option to automatically append a trailing semi-colon to each sql*plus command.
Multiple selections in the SQL History list were causing multiple screen drawing work in the command area. Fixed.