Skip to Main Content

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

Maran Viswarayar
I dont think it will be released since you have 11g in place now..Bugs from 10.2.0.4 would/will be fixed in newer version

Patches will come for 10.2.0.4 but patchset will not AFAIK

I think the terminal release of 10gr2 is 10.2.0.4
Satish Kandi
There are some references of bugs being fixed in 10.2.0.5 on Metalink but the release date is not known/published.

@OP: Are you looking for any specific bug fix? You can ask Oracle Support to provide you with a fix if it is hampering your business.
Maran Viswarayar
Thanks Sathish

I tried metalink but couldnt find any info thanks again
Ben_
10.2.0.4 is not currently detailed as a terminal patch set according to Metalink note 161818.1.
599445
i think the release will be published next year.

Senior dba ,my blog : www.youyus.com
1 - 5
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,048 views