Issue with Native SQL - Insert

[amit_khare]

Hi All,

I have a ORACLE Table with following fields -

COLUMN			NULL	DATATYPE
COMPANYCODE	        NOT NULL	NUMBER(10)
PLANVERSION		NOT NULL	VARCHAR2(30)
ORGUNIT	                NOT NULL	VARCHAR2(30)
ORGUNITSHORTTEXT        NOT NULL	VARCHAR2(50)
ORGUNITTEXT		NOT NULL	VARCHAR2(100)
STARTDATE		NOT NULL	DATE
ENDDATE			NOT NULL	DATE
MODIFIEDBY		NOT NULL	VARCHAR2(255)
MODIFIEDON		NOT NULL	DATE
STATUS			NOT NULL	VARCHAR2(3)

My code is -

EXEC SQL.
     insert into some_tab ( COMPANYCODE,
                                PLANVERSION,
                                ORGUNIT,
                                ORGUNITSHORTTEXT,
                                STARTDATE,
                                ENDDATE,
                                ORGUNITTEXT,
                                MODIFIEDBY,
                                MODIFIEDON,
                                STATUS )

                       values ( 1000,
                                '01',
                                '10001000',
                                'Test1',
                                'Test2',
                                '20100101',
                                '20101010',
                                'VIKRANTD1507',
                                '20100101',
                                'A' );

    ENDEXEC.

It's giving dump.

I searched everything but not able to find the exact reason for this.

Please advice.

Regards,

Amit

[Former Member]

What is the dump you are getting?

[Former Member]

Amit, I think there is a mismatch in the field list and the sequence of value. Hope below statement is the correct one.

insert into some_tab ( COMPANYCODE,
                                PLANVERSION,
                                ORGUNIT,
                                ORGUNITSHORTTEXT,
                                STARTDATE,
                                ENDDATE,
                                ORGUNITTEXT,
                                MODIFIEDBY,
                                MODIFIEDON,
                                STATUS )
                       values ( 1000,
                                '01',
                                '10001000',
                                'Test1',
                                '20100101',
                                '20101010',
                                'Test2',
                                'VIKRANTD1507',
                                '20100101',
                                'A' );

[amit_khare]

Thanks for Pointing Vinod.

Sequence is just printed incorrectly while re-writing the code here. Error is same

insert into some_tab ( COMPANYCODE,
                                PLANVERSION,
                                ORGUNIT,
                                ORGUNITSHORTTEXT,
                                STARTDATE,
                                ENDDATE,
                                ORGUNITTEXT,
                                MODIFIEDBY,
                                MODIFIEDON,
                                STATUS )
                       values ( 1000,
                                '01',
                                '10001000',
                                'Test1',
                                '20100101',
                                '20101010',
                                'Test2',
                                'VIKRANTD1507',
                                '20100101',
                                'A' );

With Different Changes I am getting different errors -

NATIVE SQL ERROR 925, 926, 933 & 911.