On May 8, 5:52 pm, "lazyboy..._at_yahoo.com" <lazyboy..._at_yahoo.com>
wrote:
> Thank you all for a quick response, and I like the idea of oracle
> error messages. The script will exist out when it can't retrieve the
> record in a table, and the record is always there. In other words, we
> don't have to run an insert query at all. So, does anyone know where
> the oracle error msg log file located? For instance, you run a select
> statement to display a unavailable field in a table, it'll error out
> on a terminal, but does it record it somewhere in a file as well? If
> it does, please let me know where it is & file name. I thought it's in
> one of those dump directories, but so far can't find it.
The error is most likely not going to show up anywhere if the
application does not capture it. The select will not error out if
there is no record in the result set, so you will have to code
specifically to capture the information. Can you post the content of
your script?
Received on Tue May 08 2007 - 17:02:11 CDT
