Hi,
the bind-values screen pops up even when binds are defined as below.
var Action varchar2(64);
exec :Action := ‘whatever’;
begin
dbms_application_info.set_action(:ACTION);
end;
/


Preferred behavior would be that when the bind is defined that the bind-values screen does not pop up.
Here the “and more”:
It would be nice if the data-type can be specified in the bind-value screen. The optimizer does resolve queries differently based on the data-type.
Knut