Oracle Sql Script

[MatDavies]

Hi,

I did a search but didn't find much to help me. I want to be able to run a sql script from within vb. I thought aboutusing ADO and found that this didn't work very well, in fact I think the only way I can do it would be to try and break the script down into the statements and execute them but that gets very messy....

Basically I want to be able to run DDL scripts like in Sql Navigator (very expensive...). I have read about OO4O. would this allow me to run a complete script?

Matt

If you can keep your head while those around you are losing theirs, you obviously haven't grasped the seriousness of the situation

 

[fredericofonseca]

One option is to load the whole script into a string variable and load it into a stored procedure (you can create it on the fly), and then call it.

Another way is to issue a call to SQLPLUS to run the script for you (possibly faster than loading the file, but probably slower executing the code).


Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[MatDavies]

thanks, That is an interesting Idea. to create the stored procedure to run it for me. I'll have a look into it.

cheers


Matt

If you can keep your head while those around you are losing theirs, you obviously haven't grasped the seriousness of the situation