Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Running plsql scripts
- Thread starter oluwa
- Start date
use the execute method of an ado connection.
dim cnn as adodb.connection
set cnn = new adodb.connection
cnn.connectionstring = "Provider=MSDAORA.1;Password=password;User ID=username;Data Source=myserver"
cnn.open
cnn.execute "myplsql;"
cnn.close
set cnn = nothing
hope this helps
Matt
dim cnn as adodb.connection
set cnn = new adodb.connection
cnn.connectionstring = "Provider=MSDAORA.1;Password=password;User ID=username;Data Source=myserver"
cnn.open
cnn.execute "myplsql;"
cnn.close
set cnn = nothing
hope this helps
Matt
- Status