Re: cached cursor - eliminatnig soft parses

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 25 May 2004 21:14:45 +0000 (UTC)
Message-ID: <c90d05$kfi$1@sparta.btinternet.com>

Ed,

If you email me directly I'll send you a small example of Java reusing cursors. I won't guarantee that it's good Java, but I think it demonstrates the principle.

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated May 1st


"Ed Stevens" <nospam_at_noway.nohow> wrote in message
news:mn97b09fnl7svk9tt008lajib34mfv5vuc_at_4ax.com...
>


> Yes, that is exactly what I'm after and what I was referrnig to.  The

> discussion and example is on pg. 440.  And he goes on to say "I know

> that PL/SQL will cache my cursor for me . . ."  So what I need is

> examples of how to achieve the same thing with VB, Java, and

> Pro*Cobol.

Received on Tue May 25 2004 - 16:14:45 CDT