Try this using Windows Run command (System Start button on taskbar, then click Run, paste the command, click OK). You will see that SQLPLUS will not write to the file but instead it will output to screen (in both cases > and >>). Therefore, it is SQLPLUS default behavior and it has nothing to do with the 24x7. Again, try using the SPOOL command in SQLPLUS to send all output to the file. : STILL NOT WORK!!!!!!!!!!!! : i tried something simple for you (maybee you can test it): DIM PROCESS,NUMBER : Dim command1, string "sqlplus pdupuis/password@dwh_prd @C:\\TEST.SQL : >C:\\test.log" : RunAndWait(command1, "", 0, process) : WHERE TEST.SQL IS: SELECT * FROM TABLE; : EXIT : SAME THING WITH OR WITHOUT DOUBLE BACKSLASH. : PLEASE HELP. : THANKS.
|