f&r services - getting ora-24338 while fetching much data using refcursors
hello to all,
we have a strange situation here,
we are getting plsql tables over db link, and convert them to refcursors, and set this refcursor to forms data block source.
we got no errors at our development environment, but getting FRM-40505 and ORA-24338 at production when fetching big data.
we tested using development app server and production db, to find out if there is a problem at the db stage, but it worked well at this situation.
so it abvious that there is a problem at our prod app server, maybe a different setting from the dev app server.
can pathced production cause this error ? (9.0.4.2.0)
can you point us which configuration files or parameters to look at the production app server ?
or any other comments ?
thanks a lot.
versions are:
prod db - 9.2.0.1
db linked db - 10.2.0.1
fr services prod - 9.0.4.2.0
fr services dev - 9.0.4.0.1
forms developer - 9.0.2.11.0