SQL statement problem with dump

[former_member207153]

I had problem using this command :

ABAP runtime errors : DBIF_DSQL2_INTERNAL_ERROR

exec sql.

INSERT INTO COMP_MASTER

(CompNo,CompClass,CompType,Createdby,CreatedOn)

VALUES (:compno,:compclass,:comptype,:sy-uname,:datum )

endexec.

I only encounter this during run in production env but not in dev env.

still figure out whether problem with authorization or not.

How to figure out what is the current problem for this in runtime error log?

[Former Member]

Hi Rudy

The issue with your code is that the CREATEDON field exceedes datetime datatype range value.make the createdon field a 6 character field with value xxyyzz

xx can be any two digit number

yy needs to be month value (less than 12)

zz needs to be date value (less than 31)

Try this out hope it works!!!

[Former Member]

Hi,

This shouldn't be a problem. Check in ST22 it says the statement has encountered stmt like commit work. so it gives a dump there. It doesn't give a dump in the DEV system. I guess this is because u cannot commit work there.

Regards,

Sai

[Former Member]

well you shouldnt do a exec SQL.

Open SQL offers a solution for almost every problem, so i hardly guess your requirement can be fulfilled by using OPEN-SQL only.

at least the error messages should be better then.

[former_member207153]

case close