Cursor: does the job but doesn't come back
From: Mark Brayshaw <marknal_at_perth.DIALix.oz.au>
Date: 1996/04/12
Message-ID: <4kl7mi$rq3$1_at_perth.DIALix.oz.au>#1/1
Date: 1996/04/12
Message-ID: <4kl7mi$rq3$1_at_perth.DIALix.oz.au>#1/1
I'm having an annoying problem with a cursor in SQL*plus.
I have a table of about 42000 rows that I have just loaded using SQLLoader.
One of the columns is a not_null containing the soundex of another column
of the same table. For load purposes I fill this column with a constant,
then I run a routine to loop through the table and update the column
with the correct soundex'd value.
I run the routine as anonymous block out of SQL*PLUS. I define the cursor
as a select for update where the column contains the constant. I loop for
500 records
Received on Fri Apr 12 1996 - 00:00:00 CEST