Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Error accessing package DBMS_APPLICATION_INFO

Error accessing package DBMS_APPLICATION_INFO

From: Sai <kbsai_at_rediffmail.com>
Date: 30 Oct 2002 23:54:16 -0800
Message-ID: <8ef2961e.0210302354.9393c22@posting.google.com>


Hi

I got this error while running one dayend process. There r around 600,000 rows in the table in which price_date exists. At this stage it takes around 8 minutes and ends up with this error.


Commit complete.

old 3: where price_date = '&1'
new 3: where price_date = '13-OCT-02'

old 53: where price_date < '&1')
new 53: where price_date < '13-OCT-02')
old 64: where price_date < '&1')
new 64: where price_date < '13-OCT-02')

Error accessing package DBMS_APPLICATION_INFO ERROR:
ORA-03123: operation would block


please help me out in this....
I would like to know how it is related with the package DBMS_APPLICATION_INFO.

Sai. Received on Thu Oct 31 2002 - 01:54:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US