Try MetaLink (patch the server to 8.1.7.3, and if this makes no difference,
log a TAR and have Oracle analyst to assist you in resolving this problem -
this may well be a bug that's fixed in the latest patchset).
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"Huw Dixon" <huwdixon_at_hotmail.com> wrote in message
news:8d6baabf.0204080347.4a87383e_at_posting.google.com...
> I have a package that was developed/debugged under an 8.1.6
> environment. RUns good and all queries run (using production data) in
> a matter of < 10 seconds. The package works like a champ. My problems
> began when I moved the package into our production system which is
> 8.1.7. For some reason the code seems to "hang" at the point where
> dbms_sql.fetch_rows is called. I've checked the queries and run them
> manually - they still return the data within several seconds. I've
> tried running/debugging the code from sqlplus, sql navigator, etc. and
> each time it hangs in the same place. I've tried letting it sit for
> several minutes but it does'nt return. The CPU activity definitely
> jumps on the Oracle server and then stays there. THe DBA and I have
> poured over the init.ora parameters, double checked the SYS and
> STANDARD packages to ensure all is compiled, etc.
> I've even created another 8.1.7 environment and fresh database - same
> problem. Can anyone suggest some additional points I should be looking
> at to resolve this?
>
> Thx
>
> Huw
Received on Wed Apr 10 2002 - 01:24:00 CDT
