This content has been marked as final. Show 2 replies
What you are trying is like
Target table has 3 column . source has 2 column and those 2 gets connected to your target . The un-connected column is defined as not null .
Now when your code runs it inserts value for 2 column and a null value being passed to your 3rd target column.
Oracle does not like this and it gives error.
If you remove not null column then this issue will not come other wise set a default value to this column so that when your code runs it inserts value for 2 column and oracle privieds the default value to the 3rd column.