Hi all
I am planning to make a cronjob so i would like to know if tht can be achived through
a perl script.
To be more specific, i have an Oracle RDBMS and i want to execute some commands in the
shell
.
system(sqlplus system/password);
system(drop jim cascade);
can be the above
I feel that and system() is the same thing.
Well, what i want is to import some tables from a full export dump.
The problem is that if the user's tables will be overwritten during the
automating import.
For example
system(imp system/password fromuser=(myuser) touser=(myuser)
file=export.dmp
Two ideas:
1. I'm not sure why can't you just access everything via DBI?
my $dbh = DBI-connect($connect_string, $user, $password);
$dbh-do(drop user jim cascade);
$dbh-commit();
$dbh-do(create user jim...);
2. If you really need to use system calls to SQL/PLUS why don't
you write the calls into
Details are given below on a simple Perl module I wrote called
SQL::Interpolate. I'm interested if others find this useful, find it
redundant to existing modules, or have better ideas for designing it, as
I'm considering submitting it to CPAN. (And if this is not the best
place to propose
