Re: cursor or exception


<ron.van.der.zwaag@xxxxxx> a écrit dans le message de news: 1135765418.178154.302390@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
| 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??
|

Imho, the one that is easier to read and maintain in your code.

Regards
Michel Cadot


.

Relevant Pages

  • 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)
  • Reuse of DB-API 2.0 cursors for multiple queries?
    ... I used the adodbapi module against an SQL Server Express ... I was surprised to get an exception, ... With cx_Oracle I've become used to reusing a cursor for subsequent ... raise errorclass ...
    (comp.lang.python)
  • 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)