Hi, We are using Import Excel to Database plugin to import data to Oracle DB. We are facing issue related to the primary key auto generation. We have sequence to autogenerate the primary key. But while using the plugin, we are facing the below error "???ORA-01400: cannot insert NULL into (Table_Name.Primary_Key)???". When we are trying to have a column of primary key with value, its working fine but auto generation of primary key is not happening. Is there any limitation to the plug-in?
Discussion posts and replies are publicly visible
Have you checked the information schema to make sure that there is a sequence set up to trigger on the PK?
Also, check to make sure that your excel is actually loading a null and not a blank in the column.
ChristineH Thanks for your response. It worked when we built trigger to auto-generate PK if the PK is null. I am curious if there is a limitation in the plugin for Oracle where sequence is used to auto-generate the primary key.
Make sure that there is a sequence set up to trigger on the PK.
klondike solitaire