The option to carry over "Save Values Between Session" when defining substitution variables in an editor is no longer available (v6.x) as it was in previous Nav. v5.5.
EXAMPLE:
From an SQL editor window (the Scan Defines button is already depressed to enable substitutions)
DEFINE pick_number1=1152131
DEFINE pick_number2=1152510
DEFINE pick_number3=0
DEFINE pick_number4=0
SELECT a.akey, a.aint, a.asigned, a.afloat, a.adouble, a.adecim, a.adate, a.acode, a.aname, a.aaddress, a.atimestamp
FROM a_hundred a
WHERE a.akey IN(&&pick_number1, &&pick_number2, &&pick_number3, &&pick_number4)
*Press F9 to run the DEFINE SQL, then right-click on the editor window. Select SQL/Script options, then Show Substitutions.
The four DEFINE'd values have now been set.
Next, go to another SQL editor window. Right-click just like above. Click Show Substitutions and see that none are defined in the second window. If a script that contains && type references is run none are defined and are prompted to enter them (again).
In version 5.5, when right-click and display any and all existing defined variables, there was a check box that allowed you to share those variables across all editors and sessions. In 6.1 that option has disappeared. Where is this option now?
Regression bug.
WORKAROUND:
None
STATUS:
Waiting for fix in a future version of SQL Navigator for Oracle.
May be addressed in current SQL Navigator for Oracle Beta at http://sqlnavigator.inside.quest.com/index.jspa
Note that Beta is not formally QA tested, should not be used in a production environment, and is not formally supported by Quest Support. Register for and post in the Beta Forum for assistance and feedback about the Beta version.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center