Skip to main content
anjup0143
anjup0143
December 21, 2021
Question

Import Excel To Database - Oracle DB

  • December 21, 2021
  • 3 replies
  • 0 views

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? 

    3 replies

    christineh465186
    christineh465186
    January 31, 2022

    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.

    anjup0143
    anjup0143Author
    February 1, 2022

    [mention:d4a91cb869574be08f6b7a5ae536a638:e9ed411860ed4f2ba0265705b8793d05] 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.

    Terms & ConditionsAccessibility statement