-
Title
Escape characters not applied. Result set not returning as expected. -
Description
A command to run SET ESCAPE is executed, followed by possibly multiple REGEXP_COUNT() statements. But this count does not seem to be returning as expected. The escape characters does not seem to be applied as expected. Whent he same script is run from SQL Plus, the expected counts are returned.
Other conditions that use escape characters are also not being applied as expected.
-
Cause
Toad's editor does not apply SET ESCAPE to subsequent session. In the editor, each statement is run in it's own session when executed (F9), even if the statements are in the same Toad editor window. If the SET ESCAPE is not run within the same session as the statement that uses escape characters (using F5 to run all) then the escape will not be applied.
-
Resolution
Use F5 and run the SET ESCAPE along with any statement that uses an escape charater in the same execution. Running the statements seperately will not carry through and apply the SET ESCAPE to subsequent statements run in a different session, even if it's in the same Editor window.
-
Additional Information
There is no setting to adjust this functionality. An enhancement request can be submitted to development to review this by visiting: http://www.toadworld.com/products/toad-for-oracle/i/default.aspx Do you have an idea to improve Toad for Oracle? We want to hear it! Idea Pond is where you can tell the development team what you want, and tell us how important it is by submitting, voting, and commenting on ideas. Just sign in and click the green "Submit New Idea" button to submit your idea.