--- "M.Francis" <[EMAIL PROTECTED]> wrote:
> Also a thing to keep in mind is that statements are only reusable
> as long as their hash values are exact, should another statement
> get prepared with slight alterations to the SQL this will not
deliver a match...
I can only assume that this applies to PreparedStatements as well.
For instance, Oracle says that:
INSERT INTO mytable VALUES('a','B','CC');
is different than
INSERT INTO mytable VALUES('d','E','FF');
Therefore, the second query has to be reparsed/recompiled. No? That's
my apprehension about using PreparedStatement. But, I guess Oracle is
magic enough to see the similarities and cache the query enough so
that only a parameter replacement takes place.
Unless...unless it treats the question marks like ampersands (&) in
the SQL...then that would make sense to me because then Oracle will
ask for replacement values for each question mark much the same as it
would if you were executing the query with & in place of ? in
SQLPlus. I'm just guessing at this point, however.
__________________________________________________
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
To change your membership options, refer to:
http://www.sys-con.com/java/list.cfm
