Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Using ADO Refresh against an ORACLE Database to get Parameters info for a Stored procedure(s)
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_at_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_at_rad-group.com
>
>cheers
>
>
Received on Wed May 05 1999 - 05:15:45 CDT