Loop Problem

2002-03-20 Thread Lance Prais
Can someone look at this at see what I am doing wrong: The following SQL returns to records: 50 333 select SC_USER_ID as parmSecurename from CP_USER_COMMENT where SC_ID = 107793; If I include it in the following loop the result is 50 333 333 CREATE OR REPLACE Procedure SP_USER_COMMENT_2 as

Re: Loop Problem

2002-03-20 Thread Arjen Lentz
Hi Lance, On Thu, 2002-03-21 at 03:18, Lance Prais wrote: Can someone look at this at see what I am doing wrong: The following SQL returns to records: 50 333 select SC_USER_ID as parmSecurename from CP_USER_COMMENT where SC_ID = 107793; If I include it in the following loop the result