Thread: Run Oracle
View Single Post
  #5  
Old 10-17-2007, 03:40 PM
ambalboa ambalboa is online now
Registered User
 
Join Date: 06-25-2007
Location: Houston, TX
Posts: 70
I do recall viewing an 'ADO' action step dealing with Oracle, but I don't see it anywhere in the Server.bld sample you are referring to. I do remember seeing something about running Oracle in a 'Run Program' action step. I'm thinking it was probably a .bld file that was attached to a post somewhere in the forum which I downloaded. I can't remember exactly where it is though, assuming I'm correct. I have VBP 6.2 installed. I don't have the 'Oracle' action step available but it's using SQLPlus to generate a command line. I now use the following in the 'Run Program' action step:

sqlplus -S username/password@oracleserver @C:\filepath\filename.sql

The output seems to be less, making it easier to read. Another thing, when choosing to read the output from a file, it doesn't work. I use C:\filepath\filename.txt to try and log the output in that file. I have the file created beforehand. Sometimes it doesn't run, saying it can't open the file; other times it runs but nothing is logged in the file. What am I doing wrong?
Reply With Quote