Hi,
I'm using WebLogic 10 and Oracle 10.
I'm getting an error message from Oracle saying nothing more than something like this:
"some value is too large for some column in some table. There is some precision problem".
There is no information about the value that I'm trying to insert/update.
There is no information about the column I try to insert/update.
There is no information about the table I try to insert/update.
There is no information about the SQL statement I try to execute.
All of this information is probably available in the Oracle code that throws this error message,
but the programmer that programmed that part apparently decided to not supply this information,
nor did any of his colleagues - over the past 30 years - decide that this error message is
begging to be patched.
The error comes out of the Oracle JDBC driver when I try to execute a SELECT statement.
It triggers a batch statement that is apparently delayed. It is triggered by 1 of several
thousands of SQL statements and I need to get a SQL trace.
How do I get a trace of SQL statements from Oracle? I'd guess that by now,
that is a matter of simply flipping a switch in Oracle. But somehow I get the
feeling that I'm hitting another 30-year maintenance-deprived area of Oracle...
Can anyone help me get a SQL trace from Oracle the easy way?
Regards,
Chris