Using bind variables with Oracle and VB
Posted on 2006-06-08
Could someone please provide examples of how to submit select, update, and insert SQL to an Oracle database using bind variables? (All my Google inquiries keep leading me to VB.NET code.)
Since this is an select/update that takes place every five minutes against a huge table, bind variables are essential. And I have a feeling the ADO method I used wasn't the best.
It would also be great if the examples included some error checking.
Thanks in advance for your kind response.