topic Re: Issue with Native SQL - Insert in Application Development and Automation Discussions

Issue with Native SQL - Insert

amit_khare — Wed, 08 Dec 2010 06:47:52 GMT

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

Re: Issue with Native SQL - Insert

Former Member — Wed, 08 Dec 2010 07:27:52 GMT

What is the dump you are getting?

Re: Issue with Native SQL - Insert

Former Member — Wed, 08 Dec 2010 07:49:59 GMT

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' );

Re: Issue with Native SQL - Insert

amit_khare — Wed, 08 Dec 2010 08:35:45 GMT

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.