Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Database Application Development
Windows and .NET
.NET Stored Procedures
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: May 6, 2010 2:37 PM by
Need information on running Oracle stored procedures from VB using ODP
Feb 3, 2010 7:13 PM
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.
This content has been marked as final.
Show 1 reply
Re: Need information on running Oracle stored procedures from VB using ODP
May 6, 2010 2:37 PM
in response to
It might be easier just to break down the queries into smaller peices and execute them in sequence, then put the results together later.