Xref: alice comp.databases.oracle.misc:30491 comp.databases.oracle.server:48249
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!dispose.news.demon.net!demon!news.demon.co.uk!demon!mailgate.rad-group.com!not-for-mail
From: "Mark Bate" <mark.bate@rad-group.com>
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server,microsoft.public.data.ado
Subject: Using ADO Refresh against an ORACLE Database to get Parameters info for a Stored procedure(s)
Date: Wed, 5 May 1999 10:13:19 +0100
Message-ID: <925895431.21666.0.nnrp-10.d4f0c2e2@news.demon.co.uk>
X-Trace: news.demon.co.uk 925895431 nnrp-10:21666 NO-IDENT mailgate.rad-group.com:212.240.194.226
X-Complaints-To: abuse@demon.net
X-Newsreader: Microsoft Outlook Express 4.72.3155.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0
Lines: 16

I have been informed that using the ADO refresh method against an Oracle
database to query a stored procedures parameter information is very very
slow, does anybody out there have any real world experience
of what sort of hit is envolved ??

I am thinking on the lines of a one off hit to populate an array/collection
of the parameters for each stored procedure at application startup and then
hold these cached rather than querying each time the SP is fired

Any thoughts/shared experience would be appreciated..

replys to Newsgroup and or mark.bate@rad-group.com

cheers