Hi John,
Works fine in 16.3.
Here's the spool from the Beta:
-- Session: GARDNM@LTPRDAPP
-- Timestamp: 10:07:04.715
Select column_Name
From all_tab_columns
Where Owner = :Own
And table_name = :tn
And default_length Is Not Null
And default_length > 0
And default_on_null = 'NO';
:Own(Varchar[6],In)='GARDNM'
:tn(Varchar[12],In)='XXMG_ED_MOVE'
-- Session: GARDNM@LTPRDAPP
-- Timestamp: 10:07:10.910
Select x.*, x.rowid From GARDNM.XXMG_ED_MOVE x;
And here's the one from 16.3:
-- Session: GARDNM@LTPRDAPP
-- Timestamp: 10:30:19.648
Select column_Name
From all_tab_columns
Where Owner = :Own
And table_name = :tn
And default_length Is Not Null
And default_length > 0
And default_on_null = 'NO';
:Own(Varchar[6],In)='GARDNM'
:tn(Varchar[12],In)='XXMG_ED_MOVE'
-- Session: GARDNM@LTPRDAPP
-- Timestamp: 10:30:19.880
Select * From GARDNM.XXMG_ED_MOVE Where 0=1;
-- Session: GARDNM@LTPRDAPP
-- Timestamp: 10:30:19.927
Select column_Name
From all_tab_columns
Where Owner = :Own
And table_name = :tn
And default_length Is Not Null
And default_length > 0
And default_on_null = 'NO';
:Own(Varchar[6],In)='GARDNM'
:tn(Varchar[12],In)='XXMG_ED_MOVE'
-- Session: GARDNM@LTPRDAPP
-- Timestamp: 10:30:19.996
Delete From GARDNM.XXMG_ED_MOVE;
-- Session: GARDNM@LTPRDAPP
-- Timestamp: 10:30:20.112
Insert Into GARDNM.XXMG_ED_MOVE (
PART_NUMBER, FROM_LOC, TO_LOC)
Values (
:PART_NUMBER, :FROM_LOC, :TO_LOC);
:PART_NUMBER(Varchar[15],In)=<Array[500]>
:FROM_LOC(Varchar[15],In)=<Array[500]>
:TO_LOC(Varchar[15],In)=<Array[500]>
-- Session: GARDNM@LTPRDAPP
-- Timestamp: 10:30:20.250
Commit:
-- Session: GARDNM@LTPRDAPP
-- Timestamp: 10:30:22.123
Select x.*, x.rowid From GARDNM.XXMG_ED_MOVE x;
Thanks,
Mark.