Re: Oracle's support of PreparedStatement

Peter Sylvester schrieb:
> If you don't cache on the client Oracle generally makes a hash of the
> SQL text in the server and reuses plans. Obviously you need to use bin
 d
> variables (?) for this to work, and it will require a trip to the
> server.

... but the obvious advantage is that even different PreparedStatement instances on client side that contain the same SQL code can benefit from this. and this even holds for statements in multiple connections and on multiple clients.

        robert

-- 

Robert Klemme
Software Engineer
-------------------------------------------------------------
myview technologies GmbH & Co. KG
Riemekestra e 160 ~ D-33106 Paderborn ~ Germany
E-Mail: mailto:robert.klemme_at_myview.de
Telefon: +49/5251/69090-321 ~ Fax: +49/5251/69090-399
-------------------------------------------------------------