dbTalk Databases Forums  

ORA-2042

comp.database.oracle comp.database.oracle


Discuss ORA-2042 in the comp.database.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Roger
 
Posts: n/a

Default ORA-2042 - 04-14-2004 , 12:27 PM






Hi
When I do a query "select ....." from my database several times for instance
12000 times I got error 2042 during query nr 150 and 9000 but all other
times it works fine.
Whats the problem? The select query contains 15 different fields and every
query return 5-1500 rows.
Thanks in advance





Reply With Quote
  #2  
Old   
zs
 
Posts: n/a

Default Re: ORA-2042 - 04-18-2004 , 07:47 AM






Hi

maybe this link will help you. it has the symptoms and solutions.
http://sales.esicom.com/sales/oracle...0/ds_txnma.htm
(search for 2042)

http://www.student.dtu.dk/~s021540/

"Roger" <roger.sjolin (AT) telia (DOT) com> wrote

Quote:
Hi
When I do a query "select ....." from my database several times for instance
12000 times I got error 2042 during query nr 150 and 9000 but all other
times it works fine.
Whats the problem? The select query contains 15 different fields and every
query return 5-1500 rows.
Thanks in advance

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.