©Mike Moxcey 1999

The sql() source code contd.

open (SQLCODE, ">$sql_file");
define a filehandle and open the file
print SQLCODE @sql_code;
print the SQL code to the file
close (SQLCODE);
system("$sqlplus $sql_login \@$sql_file");
make a system call to sqlplus to run the file with sql_code
unlink ("$sql_file");
delete the uneeded file


home next