[ Home  |  FAQ-Related Q&As  |  General Q&As  |  Answered Questions ]


    Search the Q&A Archives


hi, i am getting problem regarding temporary table usage...

<< Back to: [rec.humor.oracle] Intro to the Usenet Oracle (Monthly Posting)

Question by Tariq Sarwar
Submitted on 7/8/2003
Related FAQ: [rec.humor.oracle] Intro to the Usenet Oracle (Monthly Posting)
Rating: Not yet rated Rate this question: Vote
hi,
i am getting problem regarding temporary table usage
FOLLOWING ARE GIVEN THE SENARIO

the senario is :

i have a (Master --> Detail ---> SubDetail) form

     the Master and Detail Parts are displayed on canvas and have relation on block level as well as in DB,
but the third SubDetail part has only db relation and it is updated on commit.

     On PostQuery trigger in Detail Part , the related information in SubDetail is placed in a temporary table (XYZ)
this temporary table is updated on validation of a field in Detail Part.

The above mentioned process WORK FINE FOR THE FIRST TIME , BUT SECOND TIME ON EDITING A RECORD IN DETAIL PART FAILS.
AND GENERATE THE FOLLOWING ERROR

WHEN-VALIDATE-ITEM RAISED UNHANDALED EXCEPTION ORA-00600

         ----------------------
INTERNAL ERROR CODE ARGUMENTS ORA-00600 [4521],[2],[132033],[0],[4234644],[4294967295],[4294967295],[]
         ----------------------

         ----------------------
INTERNAL ERROR CODE ARGUMENTS ORA-00600 [4553],[2],[25],[],[],[],[],[]
         ----------------------

THE ABOVE ERRORS ARE RAISED IN DIFFERENT TIMES BUT ON SAME STATEMENT




Your answer will be published for anyone to see and rate.  Your answer will not be displayed immediately.  If you'd like to get expert points and benefit from positive ratings, please create a new account or login into an existing account below.


Your name or nickname:
If you'd like to create a new account or access your existing account, put in your password here:
Your answer:

FAQS.ORG reserves the right to edit your answer as to improve its clarity.  By submitting your answer you authorize FAQS.ORG to publish your answer on the WWW without any restrictions. You agree to hold harmless and indemnify FAQS.ORG against any claims, costs, or damages resulting from publishing your answer.

 

FAQS.ORG makes no guarantees as to the accuracy of the posts. Each post is the personal opinion of the poster. These posts are not intended to substitute for medical, tax, legal, investment, accounting, or other professional advice. FAQS.ORG does not endorse any opinion or any product or service mentioned mentioned in these posts.

 

<< Back to: [rec.humor.oracle] Intro to the Usenet Oracle (Monthly Posting)


[ Home  |  FAQ-Related Q&As  |  General Q&As  |  Answered Questions ]

© 2008 FAQS.ORG. All rights reserved.