Re: !!Bind variables ?

Hi , Jared & 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
Received on Wed Mar 15 2000 - 06:26:32 CST