Thank you , i ll try your suggestion!
----- Original Message -----
From: "Paul Boutros" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "dbi-users" <[EMAIL PROTECTED]>
Sent: Saturday, December 27, 2003 5:19 AM
Subject: RE: Automatng import
> 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 a file and then execute the entire file
> with one system command.
>
> open(OUT, '>', 'commands.txt');
> print OUT "drop user jim cascade;\n",
> "commit;\n",
> "create user jim...";
> close(OUT);
>
> system("sqlplus scott/tiger commands.txt");
>
> # or if you want to retain output:
> my $val = `sqlplus scott/tiger commands.txt`;
> print $val;
>
> For all the sql/plus command-line options you'll need to check
> the Oracle documentation.
>
> Paul
>
> > -----Original Message-----
> > From: John [mailto:[EMAIL PROTECTED]
> > Sent: Friday, December 26, 2003 3:38 PM
> > To: dbi-users
> > Subject: Re: Automatng import
> >
> >
> > Quoting Kevin Moore <[EMAIL PROTECTED]>:
> >
> > > 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?
>
