Hi,
Please excuse an oracle virgin coming onto the developers site, but I figured you guys will know. I have a request that has to be kicked off in 20+ databases that produces output files which we use analyse with other tools (as our contract with Oracle does not allow us to develop our own reports, or some other lame excuse). we have already automated the upload with VB, so I have been asked to see If I can automate firing off the requests from within the same tool.
I have established that I need to create an ADO connection object with the (various) databases, and create an ADO command object. but I have no idea what should be the commandText of this object.
the report has parameters.
we fire off oracle from JInitiator, so I assume that means I do not have the Oracle client on my machine (sorry I'm not too clued up on Oracle terminology).
Any help would make me a happy man. happy is good.
Thanks
FrankX
Please excuse an oracle virgin coming onto the developers site, but I figured you guys will know. I have a request that has to be kicked off in 20+ databases that produces output files which we use analyse with other tools (as our contract with Oracle does not allow us to develop our own reports, or some other lame excuse). we have already automated the upload with VB, so I have been asked to see If I can automate firing off the requests from within the same tool.
I have established that I need to create an ADO connection object with the (various) databases, and create an ADO command object. but I have no idea what should be the commandText of this object.
the report has parameters.
we fire off oracle from JInitiator, so I assume that means I do not have the Oracle client on my machine (sorry I'm not too clued up on Oracle terminology).
Any help would make me a happy man. happy is good.
Thanks
FrankX