Piper: Version 3.31 New Features and Fixes

29-Jul-2002 -- news_V331

There is now a new Toolbar Icon and a Menu Item to run 'Explain Plan' on the currently highlighted sql command. The Explain-Plan target table will be created if necessary. You can use a View option to change the name of the Explain-Plan target table.
Fixed crash that was occuring unpredictably at sql statement execution when bind variables with invalid names were present. This condition arose when a statement such as 'select count(*), xxx, yyy ..' was executed, causing Piper to automatically define a bind variable named 'count(*)'. Sometimes, on subsequent statements (even in a later session using the same saved Piper document), the attempt to bind such a variable name was causing an Oracle crash. Thus this bug affected users who were not even knowingly using the Bind Variables feature. From this release, bind var names will have invalid characters converted to underscores.