Re: Help Please

Imtiaz Ahmed wrote:
<SNIP>
> eg.
> Begin
> Declare
> Cursor X is
> select column1, column2 into :block1.field1, :block1.field2
> from table1
> where column1<100 ;
> ---
<SNIP>

I agree except:

You should leave out the "into" part when declaring the cursor:

      Cursor X is
      select column1, column2
      from table1
      where column1<100 ;

then do the fetch:

     fetch x into :block1.field1, :block1.field2 etc.

--
Anne Crowther
mailto:adf0049_at_ggr.co.uk