Re: SQL%notfound

In article <1993Jun14.203828.20224_at_news.unomaha.edu>, moswald_at_cwis.unomaha.edu (Mike Oswald) writes:
|> I thought by writing the following it would prevent the user from deleting
|> records if the record exists in a related table but it doesn't work. The
|> coded segment can be found in SQL*Forms v3, KEY-DELREC trigger.
|>
|> declare
|> cursor CNV_CUR is
|> SELECT *
|> FROM <table_1> a
|> WHERE a.field = :<block>.<field> ;
|> begin
|> if SQL%notfound then
|> delete_record ;
|> else
|> <blah>
|> end if ;
|> end ;

The SQL%... commands are set when explicit cursors are used, delete, insert single row select - Not implicit cursors. Do you really need a cursor, multiple record, when you are only deleting a single record. I see two solutions - put the <blah> processing in the exception 'no_data_found' clause, or use a cursor and open/fetch the first row. You can use the %FOUND or %NOTFOUND after the fetch.

--
 Marcus Collins                     Internet: eccmr_at_aberdeen.chevron.com
 MFI Project.                       Profs: CCMR
 Chevron (UK) Ltd.                  Phone: +44 224 242690. CTN 677-2690.
 Ninian House, Crawpeel Road, Altens, Aberdeen AB1 4LG.