Re: Automatng import

From: John (sc00170_at_cc.uoi.gr)
Date: 12/27/03

  • Next message: Dave Saville: "Install on OS/2" 
    To: "dbi-users" <dbi-users@perl.org>
Date: Sat, 27 Dec 2003 11:46:17 +0200

    Thank you , i ll try your suggestion!

    ----- Original Message -----
    From: "Paul Boutros" <Paul.Boutros@utoronto.ca>
    To: <sc00170@cc.uoi.gr>; "dbi-users" <dbi-users@perl.org>
    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:John@cc.uoi.gr]
    > > Sent: Friday, December 26, 2003 3:38 PM
    > > To: dbi-users
    > > Subject: Re: Automatng import
    > >
    > >
    > > 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?
    >

  • Next message: Dave Saville: "Install on OS/2"