Skip to Main Content

SQL Developer for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Bind-Values pops up even when set via exec :bind := value and more

Knut Härtel2 days ago

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

Comments
Post Details
Added 2 days ago
0 comments
28 views