topic Re: PL/SQL in Application Development and Automation Discussions

PL/SQL

Former Member — Tue, 07 Aug 2007 06:20:24 GMT

Hi all,

I am trying to retrieve a group of data using native sql stmts ( sellect stmnt) <> Exec sql and EndExcec .But wat happens is dat only first data gets fetched. Do i have run in it within a loop or add any other coding to retrive a group of data.

Thanks,

Kavitha

Re: PL/SQL

Former Member — Tue, 07 Aug 2007 06:25:57 GMT

Hi Kavitha,

I think you have to use DO..ENDDO (Loops)

Regards,

Atish

Re: PL/SQL

GrahamRobbo — Tue, 07 Aug 2007 23:11:17 GMT

Hi Kav,

try using a cursor. This code snippet if from the SAP Help for Native SQL.

DATA: F1(3), F2(3), F3(3). 
F3 = ' 1 '. 
EXEC SQL. 
  OPEN C FOR 
    SELECT CLIENT, ARG1 FROM AVERI_CLNT 
        WHERE ARG2 = :F3 
ENDEXEC. 
DO. 
  EXEC SQL. 
    FETCH NEXT C INTO :F1, :F2 
  ENDEXEC. 
  IF SY-SUBRC <> 0. 
    EXIT. 
  ENDIF. 
  WRITE: / F1, F2. 
ENDDO. 
EXEC SQL. 
  CLOSE C 
ENDEXEC.

Cheers

Graham

Re: PL/SQL

Former Member — Wed, 08 Aug 2007 00:31:28 GMT

Have a look at the answers to your other PL/SWL posting in Data Transfers too: