Product: Aqua Data Studio
Version: 17.0.3-15
Build #: 49106
Build Date: 2016-Mar-22 04:25:05 PM
Operating Environment: Linux (3.19.0-56-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.8.0_40-b26
Memory: Max=704,643,072; Total=394,264,576; Free=278,096,024; CPUs=8
1.Connect to Oracle DB and Create table.
create table Sample_employee(
ID VARCHAR2(4 BYTE) NOT NULL,
First_Name VARCHAR2(10 BYTE),
Last_Name VARCHAR2(10 BYTE),
Start_Date DATE,
End_Date DATE,
Salary Number(8,2),
City VARCHAR2(10 BYTE),
Description VARCHAR2(15 BYTE)
)
GO
2. Create Package and Package Body.
CREATE PACKAGE "c##project"."INV_PCK_SPEC" as
FUNCTION inv_count(qty integer) RETURN integer;
PROCEDURE inv_adjust(qty integer);
END inv_pck_spec;
GO
CREATE PACKAGE BODY "c##project"."INV_PCK_SPEC" is
FUNCTION inv_count(qty integer)RETURN integer is
new_qty integer;
BEGIN
new_qty:= qty*6;
INSERT into Sample_employee (id,salary) values ('01',new_qty);
RETURN(new_qty);
END inv_count;
PROCEDURE inv_adjust(qty integer) is
BEGIN
DELETE from Sample_employee WHERE salary<qty;
END;
BEGIN -- package initialization begins here
INSERT into Sample_employee (id, first_name)values('01', 'new');
END inv_pck_spec;
GO
3.Package and Package body generated successfully.
4.Now right click on created package, Select option "Debug in Package debugger".
5.Package debugger tab launched successfully.
6.Click on "Start" icon to execute package.
7."Execute" dialog appears, to pass parameter value in considered function/procedure.
8.Now for first object (i.e .INV_COUNT) enter value "2" in Value column.
9.After entering value , change focus to second object (i.e. INV_ADJUST),
10.You will observe that, second object (i.e INV_ADJUST) gets parameter value "2", which was actually entered for first object (INV_COST).
Expected Result :
If user changes focus of object, after entering value in "Value" column without clicking in "format" column(click event in "format" column is needed to save that parameter value for selected object),
ADS should refresh the "Value" field and should show default "blank" value.
This issue is reproducible in all ADS Versions.