topic Re: abap runtime error DBIF_DSQL2_SQL_ERROR in Application Development and Automation Discussions

abap runtime error DBIF_DSQL2_SQL_ERROR

Former Member — Wed, 25 Mar 2009 08:09:39 GMT

Hi guys,

when I run my program I got this error:

DBIF_DSQL2_SQL_ERROR

Database error text........: "ORA-01400: cannot insert NULL into

("NAPL"."KUPCI"."MSISDN")#"

my code segment looks like this:

.......

LOOP at itab.

EXEC SQL.

INSERT INTO KUPCI (POZIVNI, MSISDN, IME, PREZIME) VALUES

(:itab-poz,

:itab-tel,

:itab-name,

:itab-surname)

ENDEXEC.

ENDLOOP.

......................

KUPCI is oracle db table (with fields pozivni, msisdn, ime, prezime, )

dbcon connection is OK, what could be the problem??

thanks

nihad

Re: abap runtime error DBIF_DSQL2_SQL_ERROR

GauthamV — Wed, 25 Mar 2009 08:14:33 GMT

Check these notes.

600141

1035034.

Re: abap runtime error DBIF_DSQL2_SQL_ERROR

Former Member — Wed, 25 Mar 2009 08:25:35 GMT

Nihad,

from the exception it appaers you are passing some null value to one of the table field which has a NOT NULL property in oracle db.

Please check your table in Oracle and figure out which table fileds has NOT NULL properties i.e. it can not accept blank values.

Check in debug in what fileds you are passing NULL and violating table rules.

i hope this will solve your problem.

Re: abap runtime error DBIF_DSQL2_SQL_ERROR

Former Member — Wed, 25 Mar 2009 08:34:35 GMT

INSERT INTO KUPCI (POZIVNI, MSISDN, IME, PREZIME) VALUES

(:itab-poz,

:itab-tel,

:itab-name,

:itab-surname)

field itab-tel has some value(not null) but again I got same error??

any idea hot to solve this please?

nihad

Re: abap runtime error DBIF_DSQL2_SQL_ERROR

Former Member — Wed, 25 Mar 2009 08:53:09 GMT

Check,

Other than MSISDN , is there any other field which can not accept not null. Also check your passing primary keys of table properly.

Generally primary keys are not null value.

Edited by: santosh sarda on Mar 25, 2009 2:23 PM

Re: abap runtime error DBIF_DSQL2_SQL_ERROR

Former Member — Wed, 25 Mar 2009 09:07:48 GMT

Yes, there is one omore field other than MSISDN that is primary key and cannot accept NULL,

how to treat these fields from abap code?

thanks,

nihad

Re: abap runtime error DBIF_DSQL2_SQL_ERROR

Former Member — Wed, 25 Mar 2009 09:09:33 GMT

Pass value to that field while inserting a record in database from ABAP code.

this will resolve your issue.

Re: abap runtime error DBIF_DSQL2_SQL_ERROR

Former Member — Wed, 25 Mar 2009 09:11:56 GMT

I pass value itab-tel (not null) to MSISDN, but again error??

nihad

Re: abap runtime error DBIF_DSQL2_SQL_ERROR

former_member222860 — Wed, 25 Mar 2009 09:17:44 GMT

Hi,

If it is Primary Key, the value should be Not-Null and unique.

So, ensure that it is not a duplicate.

thanks\

Mahesh

Re: abap runtime error DBIF_DSQL2_SQL_ERROR

Former Member — Wed, 25 Mar 2009 09:19:46 GMT

Other than MSIDN, which field is not null?

Re: abap runtime error DBIF_DSQL2_SQL_ERROR

Former Member — Wed, 25 Mar 2009 10:30:39 GMT

Filed POZIVNI is primary key, NOT NULL..

thanks,

nihad

Re: abap runtime error DBIF_DSQL2_SQL_ERROR

Former Member — Wed, 25 Mar 2009 10:33:19 GMT

Check if your itab-poz has valid value.

Re: abap runtime error DBIF_DSQL2_SQL_ERROR

Former Member — Wed, 25 Mar 2009 10:36:34 GMT

it has value. thing is that in zbt_bonus I have 8 fields and in oracle KUPCI I have 12 fields

and I do:

select * from zbt_bonus into table itab.

* INSERT THE RECORDS INTO ORACLE DATABASE

LOOP at itab.
EXEC SQL.
INSERT INTO KUPCI (ID_RACUN,..........
..........

so 4 fields in KUPCI should remain empty after I insert record from abap.

these 4 fields are not primary keys...how should I declare them in sap program?

thanks,

nihad

Edited by: nihad omerbegovic on Mar 25, 2009 11:41 AM

Re: abap runtime error DBIF_DSQL2_SQL_ERROR

Former Member — Wed, 25 Mar 2009 10:52:02 GMT

Declare a type structure contaning all the fileds from KUPCI .


types :  begin of t_kupci,
            field1( 10 ) type c, " Enter actual fileds similar to KUPCI here..
            field2( 10 ) type c,
            field3( 10 ) type c,
            field4( 10 ) type c,
           ....
            filed12(10) type c
             end of type t_kupci.

data : wa_kupci type t_kupci.

LOOP at itab.

wa_kupci - field1 = itab-field1.

*and move curresponding fields from itab to kupci.
*at the end..

insert into KUPCI values wa_kupci. " Check prepoer syntax by F1 on Insert in abap editor.

endloop.

*instead of insert in loop, you can also think of collecting it in internal table and update database table directly from internal table.check the sytax in f1.

endllo.

Re: abap runtime error DBIF_DSQL2_SQL_ERROR

Former Member — Wed, 25 Mar 2009 11:54:59 GMT

what about 4 fields that are not in itab, but are contained in KUPCI?

i.e. I want to initialize

itab-id_racun = 0. gives syntax error

thanks,

nihad

Edited by: nihad omerbegovic on Mar 25, 2009 12:55 PM

Re: abap runtime error DBIF_DSQL2_SQL_ERROR

Former Member — Wed, 25 Mar 2009 12:27:27 GMT

if those 4 fileds are not specified as 'NOT NULL' in db , dont worry about them, those will be passed as initial to oracle db.

What is the syntax error you are getting? i guess you need to contact some senior ABAP devloper since it appers you have very limited knowldge of ABAP.

Please allot poits for useful answers.

Re: abap runtime error DBIF_DSQL2_SQL_ERROR

Former Member — Wed, 25 Mar 2009 16:33:56 GMT

It si resolved, error due to uncompatible data types.

Nihad

Re: abap runtime error DBIF_DSQL2_SQL_ERROR

Former Member — Tue, 31 Mar 2009 10:28:12 GMT

Hi guys,

I use dbcon to insert new record to oracle table after sale is done. Let's assume I have 10 sales and I store data in z table but can not insert into oracle table because dbcon is not temporary working. when dbcon is reconnected I want these 10 records (from the moment of last insert) to be inserted into oracle table.

How can I handle this scenario?

Thanks,

Nihad

Re: abap runtime error DBIF_DSQL2_SQL_ERROR

Former Member — Tue, 31 Mar 2009 10:28:26 GMT

have any idea?

thanks

nihad

Edited by: nihad omerbegovic on Mar 31, 2009 12:28 PM