two way I/O

John Hundley johnh at fgm.com
Thu Jul 5 18:07:12 CDT 2001


Hi,
What would be the best way to send my stdout from sqlplus to a log file
given the following code?

 $cmd1 = "| sqlplus user/password at instance";
 $cmd2 = "\@myDDL.sql"; #this sends a DDL file to sqlplus to load,  sqlplus
spits out a bunch of stuff I want to save
 $pid = open(SQLProcess, $cmd1)or die "Error msg";
 print SQLProcess "$cmd2";
 close SQLProcess;

Hope this makes sense.
Thanks,
John




More information about the Pikes-peak-pm mailing list