topic Re: Can any one please execute the program in ECC 6.0 - Dynamic Select Dump in Application Development and Automation Discussions

Can any one please execute the program in ECC 6.0 - Dynamic Select Dump

Former Member — Fri, 29 Jun 2007 19:24:05 GMT

Hi,

I am getting dump when I execute the following code in ECC 6.0 with Oracle DB. it works fine in 46, 47 unicode and non unicode and ERP2004.

If I remove the period '.' after '''4500016938''' it works fine. I just want to make sure it is ECC 6.0 issue.

TABLES: EKKO.

DATA L_WHERECOND TYPE TEXT50 OCCURS 0 WITH HEADER LINE.

CONCATENATE 'EBELN' 'EQ' '''4500016938''' '.'

INTO L_WHERECOND SEPARATED BY SPACE.

APPEND L_WHERECOND.

SELECT SINGLE * FROM EKKO

WHERE (L_WHERECOND).

WRITE: SY-SUBRC.

WRITE: EKKO-EBELN, ekko-ebeln.

I really appriciate for your help.

Thanks

Swamy

Former Member — Fri, 29 Jun 2007 19:31:08 GMT

short dump for me too in ECC6

EDIT: when i removed the '.' it worked, too.

Message was edited by:

robert phelan

RichHeilman — Fri, 29 Jun 2007 19:42:03 GMT

Yes, you do not need the "." at the end. The period is after the WHERE clause

WHERE (L_WHERECOND).    "<<---- RIGHT HERE

BTW, got a dump in my ECC6.0 system too.

Regards,

RIch Heilman

Former Member — Fri, 29 Jun 2007 19:45:13 GMT

Thanks Robert & Rich. What database you are using?

Swamy

Former Member — Fri, 29 Jun 2007 20:02:03 GMT

Thanks Robert, Can you please tell me what is database you use?

RichHeilman — Fri, 29 Jun 2007 20:13:46 GMT

We are running DB2.

Regards,

RIch Heilman