gram77
asked on
Error: SQL Error: ORA-00984: column not allowed here, while inserting a row into table.
Please see below for the table structure, and values
The statement would be interesting... A common error for this is a literal that's not under '.
ASKER
DESC xml_etc_in_repository
Name Null Type
-------------------------- ---------- ---------- ---------- ------
MSG_UID NOT NULL NUMBER(15)
EVENT_ERROR_STRING VARCHAR2(255)
EVENT_STATUS CHAR(1) MSG_TYPE_CD CHAR(5) MSG_VERSION_NO NUMBER(2)
MSG_FUNCTION_CD VARCHAR2(10)
MSG_STATUS_CD NUMBER(2)
MSG_STATUS_TXT VARCHAR2(175)
MSG_COMMENT_TXT VARCHAR2(175)
FIRM_MSG_REF_NO NUMBER(15)
CONTRA_MSG_REF_NO NUMBER(16)
REF_NO VARCHAR2(16) REF_VERSION_NO NUMBER(2)
MSG_DT DATE MSG_TIME NUMBER(6) MSG_INVALID_REASON_CD VARCHAR2(16)
MSG_INVALID_REASON_TXT VARCHAR2(175)
MSG_FORMAT_TYPE_CD VARCHAR2(3)
FIRST_MSG_TYPE_CD VARCHAR2(2)
LAST_MSG_TYPE_CD VARCHAR2(2)
HOST_PROTOCOL_ID VARCHAR2(4)
MSG_RESPONSE_TYPE_CD CHAR(1)
PRODUCT_TYPE_CD CHAR(1)
QTY_NOMINAL NUMBER(26,6)
SEC_TYPE_CD_1 VARCHAR2(8)
SEC_NO_1 VARCHAR2(12)
SEC_NAME_1 VARCHAR2(80)
SEC_TYPE_CD_2 VARCHAR2(8)
SEC_NO_2 VARCHAR2(12)
SEC_NAME_2 VARCHAR2(80)
SEC_TYPE_CD_3 VARCHAR2(8)
SEC_NO_3 VARCHAR2(12)
SEC_NAME_3 VARCHAR2(80)
COMMISSION_TYPE_CD VARCHAR2(4)
PYMT_CCY_CD VARCHAR2(3) GROSS_CONSIDER_PYMT_CCY_AM T NUMBER(15,2)
EXCHANGE_RATE NUMBER(17,10)
FIRM_ETC_ENTITY_TYPE_CD VARCHAR2(16)
CONTRA_ETC_ENTITY_TYPE_CD VARCHAR2(16)
FIRM_ETC_ENTITY_ID VARCHAR2(8)
CONTRA_ETC_ENTITY_ID VARCHAR2(8)
FIRM_ETC_ACCOUNT_ID VARCHAR2(20)
CONTRA_ETC_ACCOUNT_ID VARCHAR2(20)
FIRM_SSI_PARTY_ID VARCHAR2(175)
FIRM_SSI_ACCOUNT_ID VARCHAR2(16)
FIRM_SSI_OVERRIDE_IND CHAR(1)
SSI_CNTRY_CD VARCHAR2(3)
SSI_SETTLE_METHOD_CD VARCHAR2(12)
SSI_SEC_TYPE_CD VARCHAR2(3)
SSI_DELIV_NAME VARCHAR2(12)
CONTRA_NO VARCHAR2(20)
CONTRA_SSI_ACCOUNT_ID VARCHAR2(16)
ESPEAR_TRADE_NO CHAR(12)
ERROR_PROCESSING_IND CHAR(1)
ERROR_CD VARCHAR2(256)
LEGAL_ENTITY_ID CHAR(4)
THREAD_BUCKET NUMBER
UPDATE_TSTP DATE
Name Null Type
--------------------------
MSG_UID NOT NULL NUMBER(15)
EVENT_ERROR_STRING VARCHAR2(255)
EVENT_STATUS CHAR(1) MSG_TYPE_CD CHAR(5) MSG_VERSION_NO NUMBER(2)
MSG_FUNCTION_CD VARCHAR2(10)
MSG_STATUS_CD NUMBER(2)
MSG_STATUS_TXT VARCHAR2(175)
MSG_COMMENT_TXT VARCHAR2(175)
FIRM_MSG_REF_NO NUMBER(15)
CONTRA_MSG_REF_NO NUMBER(16)
REF_NO VARCHAR2(16) REF_VERSION_NO NUMBER(2)
MSG_DT DATE MSG_TIME NUMBER(6) MSG_INVALID_REASON_CD VARCHAR2(16)
MSG_INVALID_REASON_TXT VARCHAR2(175)
MSG_FORMAT_TYPE_CD VARCHAR2(3)
FIRST_MSG_TYPE_CD VARCHAR2(2)
LAST_MSG_TYPE_CD VARCHAR2(2)
HOST_PROTOCOL_ID VARCHAR2(4)
MSG_RESPONSE_TYPE_CD CHAR(1)
PRODUCT_TYPE_CD CHAR(1)
QTY_NOMINAL NUMBER(26,6)
SEC_TYPE_CD_1 VARCHAR2(8)
SEC_NO_1 VARCHAR2(12)
SEC_NAME_1 VARCHAR2(80)
SEC_TYPE_CD_2 VARCHAR2(8)
SEC_NO_2 VARCHAR2(12)
SEC_NAME_2 VARCHAR2(80)
SEC_TYPE_CD_3 VARCHAR2(8)
SEC_NO_3 VARCHAR2(12)
SEC_NAME_3 VARCHAR2(80)
COMMISSION_TYPE_CD VARCHAR2(4)
PYMT_CCY_CD VARCHAR2(3) GROSS_CONSIDER_PYMT_CCY_AM
EXCHANGE_RATE NUMBER(17,10)
FIRM_ETC_ENTITY_TYPE_CD VARCHAR2(16)
CONTRA_ETC_ENTITY_TYPE_CD VARCHAR2(16)
FIRM_ETC_ENTITY_ID VARCHAR2(8)
CONTRA_ETC_ENTITY_ID VARCHAR2(8)
FIRM_ETC_ACCOUNT_ID VARCHAR2(20)
CONTRA_ETC_ACCOUNT_ID VARCHAR2(20)
FIRM_SSI_PARTY_ID VARCHAR2(175)
FIRM_SSI_ACCOUNT_ID VARCHAR2(16)
FIRM_SSI_OVERRIDE_IND CHAR(1)
SSI_CNTRY_CD VARCHAR2(3)
SSI_SETTLE_METHOD_CD VARCHAR2(12)
SSI_SEC_TYPE_CD VARCHAR2(3)
SSI_DELIV_NAME VARCHAR2(12)
CONTRA_NO VARCHAR2(20)
CONTRA_SSI_ACCOUNT_ID VARCHAR2(16)
ESPEAR_TRADE_NO CHAR(12)
ERROR_PROCESSING_IND CHAR(1)
ERROR_CD VARCHAR2(256)
LEGAL_ENTITY_ID CHAR(4)
THREAD_BUCKET NUMBER
UPDATE_TSTP DATE
ASKER
************************** *****
Here is my insert statement:
************************** *****
insert into xml_etc_in_repository(
MSG_UID,
EVENT_ERROR_STRING,
EVENT_STATUS,
MSG_TYPE_CD,
MSG_VERSION_NO,
MSG_FUNCTION_CD,
MSG_STATUS_CD,
MSG_STATUS_TXT,
MSG_COMMENT_TXT,
FIRM_MSG_REF_NO,
CONTRA_MSG_REF_NO,
REF_NO,
REF_VERSION_NO,
MSG_DT,
MSG_TIME,
MSG_INVALID_REASON_CD,
MSG_INVALID_REASON_TXT,
MSG_FORMAT_TYPE_CD,
FIRST_MSG_TYPE_CD,
LAST_MSG_TYPE_CD,
HOST_PROTOCOL_ID,
MSG_RESPONSE_TYPE_CD,
PRODUCT_TYPE_CD,
QTY_NOMINAL,
SEC_TYPE_CD_1,
SEC_NO_1,
SEC_NAME_1,
SEC_TYPE_CD_2,
SEC_NO_2,
SEC_NAME_2,
SEC_TYPE_CD_3,
SEC_NO_3,
SEC_NAME_3,
COMMISSION_TYPE_CD,
PYMT_CCY_CD,
GROSS_CONSIDER_PYMT_CCY_AM T,
EXCHANGE_RATE,
FIRM_ETC_ENTITY_TYPE_CD,
CONTRA_ETC_ENTITY_TYPE_CD,
FIRM_ETC_ENTITY_ID,
CONTRA_ETC_ENTITY_ID,
FIRM_ETC_ACCOUNT_ID,
CONTRA_ETC_ACCOUNT_ID,
FIRM_SSI_PARTY_ID,
FIRM_SSI_ACCOUNT_ID,
FIRM_SSI_OVERRIDE_IND,
SSI_CNTRY_CD,
SSI_SETTLE_METHOD_CD,
SSI_SEC_TYPE_CD,
SSI_DELIV_NAME,
CONTRA_NO,
CONTRA_SSI_ACCOUNT_ID,
ESPEAR_TRADE_NO,
ERROR_PROCESSING_IND,
ERROR_CD,
LEGAL_ENTITY_ID,
THREAD_BUCKET,
UPDATE_TSTP)
VALUES
('001',
NULL,
'U',
'AE',
1,
NEW,
50,
NULL,
NULL,
63457943,
NULL,
'43613801954000',
1,
'04/28/09 10:39',
103900,
NULL,
NULL,
'511',
'AE',
'CN',
'OMGE',
'V',
NULL,
NULL,
'ISIN',
'SG1M51904654',
'CAPITAMALL TRUST',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
'HARD',
NULL,
NULL,
NULL,
'EXEC',
NULL,
'DBLDNEQ2',
'MWAMCTM',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
'840',
0,
NULL);
Here is my insert statement:
**************************
insert into xml_etc_in_repository(
MSG_UID,
EVENT_ERROR_STRING,
EVENT_STATUS,
MSG_TYPE_CD,
MSG_VERSION_NO,
MSG_FUNCTION_CD,
MSG_STATUS_CD,
MSG_STATUS_TXT,
MSG_COMMENT_TXT,
FIRM_MSG_REF_NO,
CONTRA_MSG_REF_NO,
REF_NO,
REF_VERSION_NO,
MSG_DT,
MSG_TIME,
MSG_INVALID_REASON_CD,
MSG_INVALID_REASON_TXT,
MSG_FORMAT_TYPE_CD,
FIRST_MSG_TYPE_CD,
LAST_MSG_TYPE_CD,
HOST_PROTOCOL_ID,
MSG_RESPONSE_TYPE_CD,
PRODUCT_TYPE_CD,
QTY_NOMINAL,
SEC_TYPE_CD_1,
SEC_NO_1,
SEC_NAME_1,
SEC_TYPE_CD_2,
SEC_NO_2,
SEC_NAME_2,
SEC_TYPE_CD_3,
SEC_NO_3,
SEC_NAME_3,
COMMISSION_TYPE_CD,
PYMT_CCY_CD,
GROSS_CONSIDER_PYMT_CCY_AM
EXCHANGE_RATE,
FIRM_ETC_ENTITY_TYPE_CD,
CONTRA_ETC_ENTITY_TYPE_CD,
FIRM_ETC_ENTITY_ID,
CONTRA_ETC_ENTITY_ID,
FIRM_ETC_ACCOUNT_ID,
CONTRA_ETC_ACCOUNT_ID,
FIRM_SSI_PARTY_ID,
FIRM_SSI_ACCOUNT_ID,
FIRM_SSI_OVERRIDE_IND,
SSI_CNTRY_CD,
SSI_SETTLE_METHOD_CD,
SSI_SEC_TYPE_CD,
SSI_DELIV_NAME,
CONTRA_NO,
CONTRA_SSI_ACCOUNT_ID,
ESPEAR_TRADE_NO,
ERROR_PROCESSING_IND,
ERROR_CD,
LEGAL_ENTITY_ID,
THREAD_BUCKET,
UPDATE_TSTP)
VALUES
('001',
NULL,
'U',
'AE',
1,
NEW,
50,
NULL,
NULL,
63457943,
NULL,
'43613801954000',
1,
'04/28/09 10:39',
103900,
NULL,
NULL,
'511',
'AE',
'CN',
'OMGE',
'V',
NULL,
NULL,
'ISIN',
'SG1M51904654',
'CAPITAMALL TRUST',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
'HARD',
NULL,
NULL,
NULL,
'EXEC',
NULL,
'DBLDNEQ2',
'MWAMCTM',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
'840',
0,
NULL);
ASKER
************************** *****
Error while inserting row:
************************** *****
Error at Command Line:70 Column:6
Error report:
SQL Error: ORA-00984: column not allowed here
00984. 00000 - "column not allowed here"
Error while inserting row:
**************************
Error at Command Line:70 Column:6
Error report:
SQL Error: ORA-00984: column not allowed here
00984. 00000 - "column not allowed here"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
MarkusId: THANKS!
it worked, but what was the error?
it worked, but what was the error?
Look at line 66, that's the difference (as I supposed already
in my first posting, its a literal without ').
in my first posting, its a literal without ').
ASKER
DESC xml_etc_in_repository
Name Null Type
--------------------------
MSG_UID NOT NULL NUMBER(15)
EVENT_ERROR_STRING VARCHAR2(255) EVENT_STATUS CHAR(1) MSG_TYPE_CD CHAR(5) MSG_VERSION_NO NUMBER(2) MSG_FUNCTION_CD VARCHAR2(10) MSG_STATUS_CD NUMBER(2) MSG_STATUS_TXT VARCHAR2(175) MSG_COMMENT_TXT VARCHAR2(175) FIRM_MSG_REF_NO NUMBER(15) CONTRA_MSG_REF_NO NUMBER(16) REF_NO VARCHAR2(16) REF_VERSION_NO NUMBER(2) MSG_DT DATE MSG_TIME NUMBER(6) MSG_INVALID_REASON_CD VARCHAR2(16) MSG_INVALID_REASON_TXT VARCHAR2(175) MSG_FORMAT_TYPE_CD VARCHAR2(3) FIRST_MSG_TYPE_CD VARCHAR2(2) LAST_MSG_TYPE_CD VARCHAR2(2) HOST_PROTOCOL_ID VARCHAR2(4) MSG_RESPONSE_TYPE_CD CHAR(1) PRODUCT_TYPE_CD CHAR(1) QTY_NOMINAL NUMBER(26,6) SEC_TYPE_CD_1 VARCHAR2(8) SEC_NO_1 VARCHAR2(12) SEC_NAME_1 VARCHAR2(80) SEC_TYPE_CD_2 VARCHAR2(8) SEC_NO_2 VARCHAR2(12) SEC_NAME_2 VARCHAR2(80) SEC_TYPE_CD_3 VARCHAR2(8) SEC_NO_3 VARCHAR2(12) SEC_NAME_3 VARCHAR2(80) COMMISSION_TYPE_CD VARCHAR2(4) PYMT_CCY_CD VARCHAR2(3) GROSS_CONSIDER_PYMT_CCY_AM
58 rows selected