Scan for user defined substitution variables - in SQL?
Richard Squires <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <12797649.1455171323144570968.JavaMail.SYSTEM@alvqcfw02> |
Message from: R Squires I was having a look at TOAD v11 Trial, particularly at the user defined substitution variable request in the Idea Pond: http://toadfororacle.ideascale.com/a/dtd/Scan-for-user-defined-substitution-variables/46050-8477 I hadn't read the solution properly and didn't quite understand that this was ONLY going to work fro SQL that resides inside of PLSQL. It wouldn't work for straight SQL executed within MOE. Any chance we can get this reopened so that we can get a more complete solution that doesn't rely on matching PLSQL variables being specified in order to do the bind variable substitution? I would actually use this feature more for straight SQL than I would SQL within PLSQL. Regards Richard _______________________________________ Historical Messages Author: Richard Squires Date: Mon Dec 05 20:08:59 PST 2011 I was having a look at TOAD v11 Trial, particularly at the user defined substitution variable request in the Idea Pond: http://toadfororacle.ideascale.com/a/dtd/Scan-for-user-defined-substitution-variables/46050-8477 I hadn't read the solution properly and didn't quite understand that this was ONLY going to work fro SQL that resides inside of PLSQL. It wouldn't work for straight SQL executed within MOE. Any chance we can get this reopened so that we can get a more complete solution that doesn't rely on matching PLSQL variables being specified in order to do the bind variable substitution? I would actually use this feature more for straight SQL than I would SQL within PLSQL. Regards Richard __ _______________________________________