Re: ora-4020 after migrating to 9204

From: Paul Drake <discgolfdba_at_yahoo.com>
Date: Thu, 1 Jul 2004 12:09:25 -0700 (PDT)
Message-ID: <20040701190925.21697.qmail@web20418.mail.yahoo.com>

• Raj Jamadagni <rjamya_at_yahoo.com> wrote:
  > Got a report (oracle report) that uses dynamic_sql,
  > the procedure name is get_network (defined
  > inside the report). Since we migrated to 9204 (from
  > 9202), when run from command line it shows a
  > continuous stream of ora-4020 errors ... here is a
  > snippet. No obvious open bugs found in
  > metablink.
  >
  > Since I can't read ora-4020 trace file details, does
  > anyone know what the heck is going on? I
  > know it is a self deadlock, matches a bug in (me
  > thinks) 817 ... but was (claimed) fixed before
  > 9i.
  >
  > As I search for more information, please let me know
  > if you know how to resolve these.
  > Thanks in advance
  > Raj
  

Raj,

EXECUTE IMMEDIATE in use for DML, perhaps? can you post the SQL that is causing this?

might you consider running a 10046 trace of the session?

I see these at times due to DML followed by DDL via execute immediate in a home-grown change management system, single (restricted) session of a freshly bounced database instance.

Pd

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Jul 01 2004 - 14:25:58 CDT