.net Ora 01000

[VBBoy]

Hi
i am looking for the help on this topic for long and searched lots of
sites but no one seems to provide correct solution..

i have an 3t application which takes data from oracle9i through a
middle T which is made up of remoting classes. all the classes are
singlecall but one which is singletom client has interfaces through
which they call the various methods.. the proble is the singleton
object is having a method which is called every 1 minute and performs
lots of data fetching using ref cursors processes them and makes it
ready for clients .. after few time ora-01000 exception is thrown and
system crashesh.. i am using microsoft oracle data provider.. earlier
i was using oracle dataprovider.. but it is having a bug "dataprovider
internal error" while filling datatable from adapter.. so changed to
this .
this problem is only with microsoft..i had increased open_cursor
variable to 500
but in vain..

any help please???

hemant

 

[ORi]

Which version of OracleClient provider are u using? I had the same
problem last week when using framework 1.0 and it was a bug. If you
switch to framework 1.1, the OracleClient provider no longer keeps
cursors opened.

Another solution that worked was to install the fix Q330126 you can
get from microsoft and upgraded OracleClient to 1.0.1087.0

Hope that helps,
ori