• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 871
  • Last Modified:

Syntax for Oracle bind variables with VB6

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.
1 Solution
Sounds like homework.
codefingerAuthor Commented:

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.

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....
isnt it... about of stupid "Experts" on here
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now