cursor or exception

From: "ron.van.der.zwaag@xxxxxx" <ron.van.der.zwaag@xxxxxx>
Date: 28 Dec 2005 02:23:38 -0800

Hi,

a collega used frequently a begin, select ... and exception when
no_data_found. I am used to use a cursor with %notfound to check is a
record is found.

The question is, does anyone knows what is better to do??

.

Follow-Ups:
- Re: cursor or exception
  - From: Michel Cadot

Prev by Date: Re: Problem with a date in the query !!
Next by Date: Re: Supply Date based on DOW
Previous by thread: Supply Date based on DOW
Next by thread: Re: cursor or exception
Index(es):
- Date
- Thread

Relevant Pages

Re: cursor or exception
... | a collega used frequently a begin, ... I am used to use a cursor with %notfound to check is a ...
(comp.databases.oracle.misc)
bulk insert - to make it faster
... It is taking a considerable amount of time and wanted ... CURSOR c2 (fp varchar2, ppdid number, iud date) is ... dml_errors EXCEPTION; ...
(comp.databases.oracle.server)
Re: Does this already exist ? TAction with Mouse-Cursor support.
... default crHourglass; ... function THerzogAction.DoAborted: Boolean; ... I set the cursor back to normal before calling DoAborted because I'm ... Instead of catching every exception, it might make sense to only catch ...
(borland.public.delphi.language.objectpascal)
Recommendations (or best practices) to define functions (or methods)
... I would like to know about a web site or documentation that ... def ExecuteSQL(cmdSQL, cursor): ... except Exception, e: ...
(comp.lang.python)
Re: Recommendations (or best practices) to define functions (or methods)
... I would like to know about a web site or documentation that ... def ExecuteSQL(cmdSQL, cursor): ... except Exception, e: ...
(comp.lang.python)