A-ha. This may be the reason. My database is 9.2 the other is 7.3. I bet that't the problem.
thanks Gene --- Kevin Lange <[EMAIL PROTECTED]> wrote: > I was getting that when I tried to select accros a > DB Link when my Database > and my Client Code were at different levels. > > In our case, Database 8.0.5 and Client Code of 8.1.7 > caused a failure. > > Since we upgrade our database to 8.1.7 all is well. > > What are the versions of your client code and > database ?? > > Kevin > > -----Original Message----- > Sent: Tuesday, January 07, 2003 4:34 PM > To: Multiple recipients of list ORACLE-L > > > HI. > > Does anyone have any info regarding ora-1002 error > "fetch out of sequence"? All the info I've found on > the MEtalink is referring to a PL/SQL or a select > for > update. All I'm doing is select from table@dblink > and I'm getting ora-1002. I set autocommit off, but > this didn't help. Does anyone have any ideas? > > thanks > > > Gene > > __________________________________________________ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up > now. > http://mailplus.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Gurelei > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > San Diego, California -- Mailing list and web > hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Kevin Lange > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > San Diego, California -- Mailing list and web > hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
