<div>
This seems to be a bug.<br />
To see details look in the trace (.trc).<br />
Possibly you find there the SQL involved in this error<br />
and decide if this is a bug or application error.
</div>


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.

<div>
Thanks Schwertner,<br />
<br />
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? <br />
<br />
Regards,<br />
Ken<br />
<br />

</div>


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



<div>
<div class="content wysiwyg-content">
Hi experts,<br />
<br />
Today I got a err msg in bdump in my oracle 10g DB as follows:<br />
<br />
~~~~~~~~~~~~~~~~~~~~~~~~~~<wbr />~~~~~~~~~~<wbr />~~~~~~~~~~<wbr />~~~~~~~~~~<wbr />~<br />
*** SERVICE NAME:(SYS$BACKGROUND) 2008-06-10 23:35:21.574<br />
*** SESSION ID:(549.1) 2008-06-10 23:35:21.574<br />
*** 2008-06-10 23:35:21.574<br />
SMON: following errors trapped and ignored:<br />
ORA-00604: error occurred at recursive SQL level 1<br />
ORA-01461: can bind a LONG value only for insert into a LONG column<br />
~~~~~~~~~~~~~~~~~~~~~~~~~~<wbr />~~~~~~~~~~<wbr />~~~~~~~~~~<wbr />~~~~~~~~~~<wbr />~~<br />
<br />
How can I go into detail to check which recursive SQL statement having problem? <br />
<br />
Best Regards,<br />
Ken<br />
<br />

</div>
</div>


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



err msg in bdump

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.