Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL Procedure call from ado
A few suggestions:
-- 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. "Mark Wallace" <markdw71-No_at_S-p-a-m-hotmail.com> wrote in message news:Juis8.5$Re4.671_at_news.lhr.globix.net...Received on Wed Apr 10 2002 - 01:20:06 CDT
> We are having the following problem...
>
> When using ADO to call a PL/SQL package that returns a recordset from the
> oracle database, the call takes excessively long, but only on one of our web
> servers!!
> On another web server with the same software setup, i.e. same service packs,
> same oracle client etc, etc the call is almost instantaneous.
> I am have uninstalled, re-installed ...
> service packs...
> Oracle client...
> our software...
> numerous times to see if I could track it down. No luck.
>
> Also when doing standard select queries down to the database (also with ADO)
> it all works great.
> It is just when try to call a PL/SQL package that the one server is hugely
> slower that the other.
>
> Any help would be greatly appreciated.
>
> Summary of our setup :
> ==========================================================
> Client Machine :
> Oracle Client 8.1.7
> OraOLEDB provider 8.1.7.2 (latest version downloaded from oracle)
> IIS 4
> Win NT4 server with service pack 6a
>
> Server Machine :
> Oracle 8.1.6
> ==========================================================
>
> Regards
> Mark
>
>