Someone please tell me I'm reading this wrong;
http://radio.weblogs.com/0118231/stories/2003/03/05/clarifyingSomeBindVariableConfusion.html
I read this as;
If you're using the Oracle JDBC drivers then you should use the Oracle
style of bind variables, ":NNN" style, rather than the standard JDBC
"?" character, because it's faster. You should be able to use
":AnyNameYouLike", but you can't because the JDBC drivers are broken,
and have been for ages. So you have to just use numbers to name them.
The numbers however don't actually mean anything, you still have to
bind them in exactly the same way as if they were standard JDBC "?"
characters! In the example they have the binds ":54", ":2", ":17",
":2", ":11" and ":99" which you have to bind (with
"setWhereClauseParam", even though some of them aren't in the where
clause!) as 0, 1, 2, 3, 4 and 5. Remembering that you have to bind ":2"
twice, in different positions, obviously.
Surely I'm misunderstanding this, otherwise WTF is the point of Oracle having their own special bind variable style?
S
Sayonara
@Sayonara
0
Reputation
1
Posts
28
Profile views
0
Followers
0
Following
Best posts made by Sayonara
This user hasn't posted anything yet.
Latest posts made by Sayonara
-
In a Bind