<div>
<br />
Hmmmm....yeah, it does, sorry.<br />
<br />
Let me rephrase &nbsp;... &nbsp;(can't edit or delete)<br />
<br />
Could someone please provide examples of how to submit select, update, and insert SQL to an Oracle database using bind variables? &nbsp; (All my Google inquiries keep leading me to VB.NET code.) &nbsp; <br />
<br />
Since this is an select/update that takes place every five minutes against a huge table, bind variables are essential. &nbsp;And I have a feeling the ADO method I used wasn't the best.<br />
<br />
It would also be great if the examples included some error checking.<br />
<br />
Thanks in advance for your kind response.<br />
<br />
<br />
<br />
<br />
<br />
<br />

</div>



Hmmmm....yeah, it does, sorry.

Let me rephrase  ...  (can't edit or delete)

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.








<div>
It might have been homework but I would really like to have seen the answer here so I could have used it for my work.<br />
<br />
What use is this being here as a &quot;solution&quot;??<br />
<br />
Frustrating website this can be sometimes....
</div>


It might have been homework but I would really like to have seen the answer here so I could have used it for my work.

What use is this being here as a "solution"??

Frustrating website this can be sometimes....

<div>
isnt it... about of stupid &quot;Experts&quot; on here
</div>


isnt it... about of stupid "Experts" on here

<div>
<div class="content wysiwyg-content">
Please provide examples of how to submit select, update, and insert SQL to an Oracle database. &nbsp; Use bind variables in your examples. &nbsp; Include some error checking.
</div>
</div>


Please provide examples of how to submit select, update, and insert SQL to an Oracle database.   Use bind variables in your examples.   Include some error checking.

Syntax for Oracle bind variables with VB6

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.