Re: Lost place in temporary table

[Anne-Marie Matula <amatula@OIT.UMASS.EDU>]

> Peggy McCall <peggy.mccall@PHARMA.NOVARTIS.COM> wrote:
>Are you doing any kind of COMMIT in your 2200-process-employee
>subroutine?
>That will trigger the cursor to 'reset' and you will get an
>endless loop
>like you describe.

Is this true for all begin-select end-select blocks?  I've used commit
before within a select statement and haven't seen any problems.

Forgive me if I missed the obvious - I worked this weekend and my brain
circuits are dead!

Thanks!
Anne-Marie Matula

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Student Information System Project
Office of Information Technologies
Whitmore Bldg, University of Massachusetts, Amherst
Phone:  413/577-0685
Fax:    413/545-2150