Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: XE cursor handling
On Mar 27, 11:44 am, "Tarby777" <tarbs..._at_yahoo.com> wrote:
> Hi all,
>
> I hesitate to post this because it sounds silly even to me, but here
> goes...
>
> A colleague is adamant that with open_cursors set to the same value in
> a 9i database and an XE database, he can complete a certain operation
> (in our app) successfully on 9i, but runs out of cursors when he does
> the same thing on XE. Can this be true? No-one else is using the
> databases...
>
> TIA
> Tarby
Without further specifics
</rant> Why is it so difficult to post more than 'It doesn't work'?
Why does everyone assume, there is a bunch of mindreaders here,
whereas Oracle Technical Support requires you to provide a shitload of
information? Even specifying the value of open_cursors is already
evidently asked to much! Why does everyone just DUMP their issue,
without doing ANY research of their OWN? Assuming we will do the work
they are just a tad too lazy for? </end rant>
one can only assume, because of an empty datadictionary, recursive SQL
has to be performed. Obviously each recursive SQL statement requires a
cursor.
-- Sybrand Bakker Senior Oracle DBAReceived on Tue Mar 27 2007 - 05:43:45 CDT