hi

assuming you use DBI & DBD::Oracle, here's a snippet from the DBI documentation:

Perform whatever processing is necessary to execute the prepared statement. An undef is returned if an error occurs. A successful execute always returns true regardless of the number of rows affected, even if it's zero (see below). It is always important to check the return status of execute (and most other DBI methods) for errors if you're not using /RaiseError

see also this

hth
emanuel