It has been many years since my last question ;p
Consider a basic table
create table abc(
insert into abc values ('Scott',sysdate,1);
This will run fine
select a, b, c
This will raise ora-01858
select b,a, c -- note column order
So if the code is working fine in one db, and in another the column order in the table is different, then I will get an error because of the positional notation.
Is there another method beyond reordering columns to fix this?
It seems reminiscent of using this without naming column order.
insert into abc values (...)