Re: PL/SQL: Scope of Cursor FOR Loop Records

From: Ubiquitous <weberm_at_polaris.net>
Date: Fri, 06 Dec 2002 17:05:16 -0600
Message-ID: <8CGdnZThDKuxsGygXTWc3g@comcast.com>

In article <WS4I9.3491$iu6.104695056_at_newssvr13.news.prodigy.com>, kfarrell_at_belgariad.com wrote:

>> IF cursor_record.action_flag = '1' THEN
>> [A update_table1
>
> update_table1 (cursor_record.key)
>
>> ELSIF cursor_record.action_flag = '2' THEN
>> update_table2
>
> update_table2 (cursor_record.key)
>
>> ELSE
>> /* error logic */
>> END IF;
/*slaps forehead with hand */
Dooh! I guess I've been working with COBOL too long; Thanks! Received on Fri Dec 06 2002 - 17:05:16 CST