Skip to Content
author's profile photo Former Member
0
Former Member

abap runtime error DBIF_DSQL2_SQL_ERROR

Posted on Mar 25, 2009 at 08:09 AM 17 Views

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Mar 25, 2009 at 08:25 AM
    1

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Mar 25, 2009 at 12:27 PM

      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.

    Comment on This Answer
  • author's profile photo Gautham Vangaveti
    Gautham Vangaveti
    Posted on Mar 25, 2009 at 08:14 AM
    0

    Check these notes.

    600141

    1035034.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 25, 2009 at 04:33 PM
    0

    It si resolved, error due to uncompatible data types.

    Nihad

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 31, 2009 at 10:28 AM
    0

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 31, 2009 at 10:28 AM
    0

    have any idea?

    thanks

    nihad

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.