This discussion is archived
1 Reply Latest reply: May 6, 2010 12:37 PM by 770968 RSS

Need information on running Oracle stored procedures from VB using ODP

751352 Newbie
Currently Being Moderated
Hi. I'm trying to run some complex queries on a list of Oracle databases from a VB application using ODP.

I've been able to execute simple queries formatted as strings on all 150 databases with no problems. Now, however the queries are more than 100 lines, and it's not practical to handle them as strings.

Can anyone point me to reference material or some samples that would show how to to this?

I've gone through this forum, but I haven't found anything starting from the very basics, which is what I need.

Many thanks


  • Correct Answers - 10 points
  • Helpful Answers - 5 points