err msg in bdump

Hi experts,

Today I got a err msg in bdump in my oracle 10g DB as follows:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
*** SERVICE NAME:(SYS$BACKGROUND) 2008-06-10 23:35:21.574
*** SESSION ID:(549.1) 2008-06-10 23:35:21.574
*** 2008-06-10 23:35:21.574
SMON: following errors trapped and ignored:
ORA-00604: error occurred at recursive SQL level 1
ORA-01461: can bind a LONG value only for insert into a LONG column
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

How can I go into detail to check which recursive SQL statement having problem?

Best Regards,
Ken

kentangaAsked:
Who is Participating?
 
schwertnerCommented:
What is the version of 10g?
If it is Release 1 migrate to Release 2.
If it is Release 2 upgrade to 10.2.0.4
Visit in metalink will not hurt, but upgrade
is the best way.
0
 
schwertnerCommented:
This seems to be a bug.
To see details look in the trace (.trc).
Possibly you find there the SQL involved in this error
and decide if this is a bug or application error.
0
 
kentangaAuthor Commented:
Thanks Schwertner,

I checked the trace files of smon and I could not find out more relative and detail information. Should I check it in metalink for possible known bug recorded in oracle?

Regards,
Ken

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.