Xref: alice comp.databases.oracle.misc:30502 comp.databases.oracle.server:48260
Path: alice!news-feed.fnsi.net!news.idt.net!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: Re: Using ADO Refresh against an ORACLE Database to get Parameters info for a Stored procedure(s)
Date: Wed, 5 May 1999 12:03:19 +0100
Message-ID: <925902037.24379.0.nnrp-10.d4f0c2e2@news.demon.co.uk>
References: <925895431.21666.0.nnrp-10.d4f0c2e2@news.demon.co.uk> <#SqP6Aul#GA.52@cppssbbsa02.microsoft.com>
X-Trace: news.demon.co.uk 925902037 nnrp-10:24379 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: 35

Sure, I appreciate that you can specify params in code, however my
colleagues are lazy buggers and the idea of having to append x number of
parameters, even if I wrap this functionality in a method starts them
winging...ie for instance one of our stored procs will take 40-50 params...


Tonix wrote in message <#SqP6Aul#GA.52@cppssbbsa02.microsoft.com>...
>Why incur the hit if you don't have to ?
>All that needs doing is that you specify the parameters to the stored procs
>in code.
>
>Mark Bate wrote in message
><925895431.21666.0.nnrp-10.d4f0c2e2@news.demon.co.uk>...
>>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
>>
>>
>
>