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 .
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center