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.