DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Run SQL Script via ADO from Visual Basic

719655Aug 27 2009 — edited Aug 28 2009

Hi,

I have a process in place that processes sql scripts in batch. This process is written in Perl and for each script it starts an sqlplus process and executes the script.

What I am wondering is if there is a way to do this using ADO in Visual Basic. I have been able to write the code to process oracle commands (one at a time) but what I would like to know is if there is a way to just pass a script to oracle from VB as a string and ask it to process it without going through sqlplus. I don't want to modify any of the .sql files. The .sql files run oracle commands like SELECT, DROP, INSERT, etc and also Spools output to files.

Maybe Oracle has a different API that I should be using to do this?

Any help would be greatly appreciated.

Thanks,
Neil

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 25 2009

Added on Aug 27 2009

#oracle-provider-for-ole-db, #windows-and-net

2 comments

3,634 views