Re: Automatng import

From: John (John_at_cc.uoi.gr)
Date: 12/26/03 

Date: Fri, 26 Dec 2003 22:38:01 +0200
To: dbi-users <dbi-users@perl.org>

Quoting Kevin Moore <kmoore@esntech.com>:

> Try "drop user jim cascade"
>
> John wrote:
>
> >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 done? To execute internal commands as the sqlplus programs
> provides?
> >
> >
>
>

I am afraid that this trick isn't going to work as far as system() will be
waiting until the sqlplus command ends.

What do you say?