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?
|