Originally Posted by
davey23uk
the error is perfectly clear
cannot insert NULL into ("QUARKDMS"."MAM_ASSETS"."INDEX_SOURCE")
stop trying to insert nullls into the column
It's import which is inserting. How can I control it. The column is BLOB type.
Structure of mam_assets is:
Code:
ID NOT NULL NUMBER(10)
ACL_ID NOT NULL NUMBER(10)
ASSET_GROUP_XID NOT NULL NUMBER(10)
NEW_VERSION_ASSET_ID NUMBER(10)
CONTAINED_IN_COUNT NOT NULL NUMBER(6)
CONTAINER_OF_COUNT NOT NULL NUMBER(6)
RELATED_WITH_COUNT NOT NULL NUMBER(6)
ARCHIVE_STATUS NOT NULL NUMBER(1)
IS_CURRENT_VERSION NOT NULL NUMBER(1)
STORAGE_CHANGE_REQUEST NOT NULL NUMBER(1)
HAS_HISTORY NOT NULL NUMBER(1)
FAMILY_ID NOT NULL NUMBER(10)
CHECKED_OUT_BY NUMBER(10)
NAME VARCHAR2(255)
LC_NAME VARCHAR2(255)
CHECKOUT_LOCATION VARCHAR2(255)
LC_CHECKOUT_LOCATION VARCHAR2(255)
ASSET_SIZE NUMBER
REVISION NUMBER
FILE_DATE_LAST_MODIFIED DATE
FILE_DATE_CREATED DATE
FILE_EXTENSION VARCHAR2(255)
FILE_TYPE VARCHAR2(255)
FILE_CREATOR_APPLICATION VARCHAR2(255)
LC_FILE_EXTENSION VARCHAR2(255)
LC_FILE_TYPE VARCHAR2(255)
LC_FILE_CREATOR_APPLICATION VARCHAR2(255)
DATE_CREATED DATE
DATE_LAST_MODIFIED DATE
DATE_CHECKED_OUT DATE
OWNER NUMBER(10)
CREATED_BY NUMBER(10)
LAST_MODIFIED_BY NUMBER(10)
DESTINATION_ID NUMBER(10)
LAST_ACTIVITY_ID NUMBER(10)
LAST_ACCESSED_BY NUMBER(10)
DATE_LAST_ACCESSED DATE
PREVIOUS_REVISION NUMBER
FIRST_VERSION_CREATED_BY NUMBER(10)
FIRST_VERSION_DATE_CREATED DATE
FTS_TEXT_MC CHAR(1)
FTS_TEXT_UC CHAR(1)
FTS_TEXT NOT NULL CLOB
FTS_LANG NOT NULL VARCHAR2(3)
INDEX_SOURCE NOT NULL BLOB
Reply With Quote