Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: JAVA Developer

RE: JAVA Developer

From: <oracle-l-bounce_at_freelists.org>
Date: Tue, 9 Jan 2007 13:53:27 -0000
Message-ID: <5A8896FB2AFC5445A7DCFC5903CCA6B06FEC14@W03856.li01r1d.lais.net>

BTW, proper tools should do this parsing optimization for developer. Oracle´s Java Developer ADF framework is quite good in that respect. Anyway, a good Java developer should know this concept at least in order to be able to evaluate Java technologies.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Norman Dunbar
...

so the so called prepared statement is treated as just another unprepared statement. The code really should be as follows :

begin
  if statement in not yet prepared then     parse statement
  end if

  bind variables
  execute statement
  process results
end

...

Fyrirvari/Disclaimer
http://www.landsbanki.is/disclaimer

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 09 2007 - 07:53:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US