29-Jul-2002 -- news_V331
Piper: Version 3.31 New Features and Fixes
Previous News Item
Next News Item
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.
Back to list of News Items
Piper Homepage