When we try to publish to Target database (Oracle) a row with a null value it wont show the column. We are getting -
ORA-00947: not enough values
It will upload an image and sql text file created by publishing. But not when you try to publish to a target database.
This error can occur when you are performing an INSERT and the values entered are less in number than the columns that you are inserting into.
Make sure the INSERT Query Insert rows the same number as that columns that you are inserting into.