topic Re: Native SQl query in Application Development and Automation Discussions

Native SQl query

Former Member — Thu, 17 Aug 2006 07:38:50 GMT

I want to reduce the database hit for the external database so i'm trying to use cursor. I'm following the F1 help syntax. But problem is it is giving Dump in the FETCH NEXT statement. Please help.

EXEC SQL.

OPEN C1 FOR SELECT SAP_MASTNR, ANK_MASTNR FROM

NOVARTIS.TABLE_ADRESS@ANKD WHERE ANK_MASTNR IN :wa_datlt ;

ENDEXEC.

DO.

EXEC SQL.

FETCH NEXT C1 INTO :wa ;

ENDEXEC.

IF SY-SUBRC <> 0.

EXIT.

ENDIF.

ENDDO.

EXEC SQL.

CLOSE C1

ENDEXEC.

Re: Native SQl query

Former Member — Thu, 17 Aug 2006 07:43:55 GMT

Hi Phani,

if you are using Oracle, the correct syntax should be "fetch cursor_name into variable".

I hope it helps. BR,

Alvaro

Re: Native SQl query

Former Member — Thu, 17 Aug 2006 08:16:04 GMT

Hi Even then it is giving dump. And one more thing the value in the wa_datlt contains this ( '005236' , '36587' , '36587' ).

If i skip that where clause or if the variable wa_datlt contains single value it is working fine. What could be the reason?