tag:blogger.com,1999:blog-18544104.post114849077324867614..comments2024-01-13T10:17:55.043-08:00Comments on Stephen's Oracle Blog: Solution to Dreaded ORA-07445 errorStephen Boothhttp://www.blogger.com/profile/18227774573735486445noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-18544104.post-1153317210895755142006-07-19T06:53:00.000-07:002006-07-19T06:53:00.000-07:00So far as I am aware there were a few similar que...So far as I am aware there were a few similar queries that we causing this error, one example was:<BR/><I>select all count(dm_type.r_object_id) "the_count" from dm_type_sp dm_type where (dm_typ<BR/>e.name=:"SYS_B_0" and exists (select r_object_id from dm_type_r where dm_type.r<BR/>_object_id = r_object_id and attr_name=:"SYS_B_1"))</I><BR/><BR/>The error is caused when you try to use the count()Stephen Boothhttps://www.blogger.com/profile/18227774573735486445noreply@blogger.comtag:blogger.com,1999:blog-18544104.post-1153316785937706622006-07-19T06:46:00.000-07:002006-07-19T06:46:00.000-07:00Hi Stephen,Thank you for posting your experiences ...Hi Stephen,<BR/><BR/>Thank you for posting your experiences for others :) May I ask you if you found the offending query and what the before-and-after versions looked like?Anonymousnoreply@blogger.com