RE: !!Bind variables ?

From: Thapliyal, Deepak <DThapliyal_at_ea.com>
Date: Thu, 11 May 2000 14:44:18 -0700
Message-Id: <10494.105431@fatcity.com>

by looking at parse count o/p for value > 1

-----Original Message-----
From: Nidhi Jain [mailto:nidhi_at_kinecta.com] Sent: Thursday, May 11, 2000 2:10 PM
To: Andrey Bronfin; oracledba_at_quickdoc.co.uk; ORACLE-L_at_fatcity.com Subject: RE: !!Bind variables ?

How did u find in the TKPROF that the statement was parsed again?

Nidhi

-----Original Message-----
From: Andrey Bronfin [mailto:bronfin_at_VisualTop.com] Sent: Wednesday, March 15, 2000 5:44 AM
To: oracledba_at_quickdoc.co.uk; ORACLE-L_at_fatcity.com Subject: Re: !!Bind variables ?

> Hi , ALL !
> I'm staled with the same problem here ... We need the programmers to use
> bind variables in Java programs , since i have the same query repeated
many
> times with different parameters .
>
> select ename from emp where emp_id=??? ;
> The "???" is always different .
>
> As U suggested , I looked at technet , and found nothing but the use of
> PreparedStatement .
> We tried it and seen in the TKPROF output that the satements are still
> parsed every execution ....
>
> Does anyone have any experience with this , please ....
> Any parameters that need to be adjusted except for the Java code itself ?
>
> Thanks a lot in advance ...
>
> ----- Original Message -----
> From: "Jared Still" <jkstill_at_bcbso.com>
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Friday, May 05, 2000 7:36 PM
> Subject: Re: !!Bind variables ?
>
>
> >
> > Goto to technet.oracle.com and look at the sample code.
> >
> > There's likely samples of what you are looking for.
> >
> > This is assuming that of course, you have already
> > looked at the documentation.
> >
> > Jared
> >
> > On Wed, 3 May 2000, Just Started wrote:
> >
> > > Hi , DBAs !
> > > Please help :
> > >
> > > How can bind variables be used & implemented with with Java ?
> > > Does anyone have an example / paper /link ?
> > >
> > > TIA .
> > >

---

> > > Get Your Private, Free E-mail from MSN Hotmail at
http://www.hotmail.com
> > >
> > > --
> > > Author: Just Started
> > > INET: new_oracle_at_hotmail.com
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing Lists
> > > --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> > >
> >
> >
> > Jared Still
> > Certified Oracle DBA and Part Time Perl Evangelist ;-)
> > Regence BlueCross BlueShield of Oregon
> > jkstill_at_bcbso.com - Work - preferred address
> > jkstill_at_teleport.com - private
> >
> >
> > --
> > Author: Jared Still
> > INET: jkstill_at_bcbso.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>

---

If you're bored, then visit the list's website: http://www.lazydba.com (updated daily)
to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk

---

If you're bored, then visit the list's website: http://www.lazydba.com (updated daily)
to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk Received on Thu May 11 2000 - 16:44:18 CDT