Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Capture SQL that is causing an error

118236Dec 4 2008 — edited Dec 8 2008
We have this application that I can no longer see the source code. (it is being presently redeveloped). I have encountered a particular situation where a user of the app receives an Oracle error reporting "more than 2 rows have been returned" and the app will not proceed.

What I need to do is see what SQL the application is sending to Oracle that generates this error. I know the error has to do with the data in our database as this error only occurs with specific records being entered, I just need to know where to look.

I have used v$sql, but it only records the statements right prior to the one that I am interested in.

Is there a way to find out what the application is sending to Oracle successfully or unsuccesfully?

We are running Oracle 9.2 on Intel.

Thanks
This post has been answered by 469753 on Dec 5 2008
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 5 2009
Added on Dec 4 2008
19 comments
1,015 views