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!

Query-Window for Bind-Values pops up if using no-default referencing

Bernd MainzFeb 4 2026

Extension pops up window/frame asking for BIND-Value(s) if non-default referencing used in “create trigger”-Statements.

Example taken from official documentation (19c):

create table new (
field1 number,
field2 varchar2(20)
);

create or replace trigger print_salary_changes before
update on new
referencing
new as newest
for each row
begin
:newest.field2 := to_char(:newest.field1);
end;
/
Comments
Post Details
Added on Feb 4 2026
1 comment
49 views