Parameters are not being passed in the execution window.
1.Execute any procedure that has input parameters.For example the one below:
CREATE OR REPLACE PROCEDURE TestParameters (param1 number)IS
BEGIN
null;
END TestParameters;
/
2. select the procedure in the Schema Browser , r-click and select "Execute Function"
3.Enter a value for the parameter param1.For example 4.
The value is not updated in the code :
DECLARE
PARAM1 NUMBER;
BEGIN
PARAM1 := NULL;
HIEU.TESTPARAMETERS (PARAM1);
:PARAM1 := PARAM1;
COMMIT;
END;
Check the param1 is set to NULL.
in previous versions you need to click on the editor below so this is updated but in this version this is not updated even when clicking.
Note that the code is executed with the null value .
WORKAROUND
Change the value manually in the code generated and not trough the parameter window
STATUS
Issue fixed in version 12.9. The latest version of Toad for Oracle can be downloaded at: https://support.quest.com/toad-for-oracle/download-new-releases
