Re: ORA-02035 illegal bundled operation combination

Hi,

Thanks for responding. I'm logging into SQL+ in 2 different locations, but connecting to the same Oracle instance in both cases. The SQL+ in Switzerland is a later version than the US--I suspect that it has something to do with the network, but don't have a clue (and don't know where to look!)

I can post the code if that would help, but it's really very simple. I do create a cursor, however.

Steve

jonathan_at_jlcomp.demon.co.uk (Jonathan Lewis) wrote in <b19347$ghc$1$8300dec7_at_news.demon.co.uk>:

>
>This is just a guess - but do you have different
>versions of the database software running at
>the two sites ? Or have you compiled some
>part of your application with different versions
>of OCI ?
>
>Recent versions of Oracle play all sorts of
>network optimisation games by bundling calls
>to the server, e.g. a call to close a cursor
>may not be sent until the next call to open
>a new cursro. It is possible, therefore, that
>a super new version of the software will do
>something that the boring old version of the
>software can't cope with.
>
>
>--
>Regards
>
>Jonathan Lewis
>http://www.jlcomp.demon.co.uk
>
>Coming soon a new one-day tutorial:
>Cost Based Optimisation
>(see http://www.jlcomp.demon.co.uk/tutorial.html )
>
>____UK_______March 19th
>____USA_(FL)_May 2nd
>
>
>Next Seminar dates:
>(see http://www.jlcomp.demon.co.uk/seminar.html )
>
>____USA_(CA, TX)_August
>
>
>The Co-operative Oracle Users' FAQ
>http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
>
>StephenHirsch wrote in message <3e380e2e_at_guardhouse.chbs>...
>>Subject: ORA-02035 illegal bundled operation combination
>>Newsgroups: Novartis News Server:comp.database.oracle.server
>>
>>Hi,
>>
>>I'm getting this error message that I've never seen before. My
>anonymous block
>>with a cursor runs perfectly when I connect to the US Oracle instance
>from a US
>>Unix server; however, when I run the exact same code on a server
>located in
>>Switzerland, I get the ORA-02035 illegal bundled operation
>combination message.
>>What's up with that, anybody?
>>
>>Oracle's documentation isn't much help. It says:
>>
>>Cause: User requested that the UPI bundled execution call perform an
>illegal
>>combination of operations.
>>
>>Action: Use a legal combination of operations and retry.
>>
>>That seems like it was written at 3 in the morning ((:=))
>>
>>Thanks in advance for your help,
>>
>>Steve
>
>
>
Received on Wed Jan 29 2003 - 12:37:11 CST