In typical Perl fashion (for me, anyway), I have no idea what the problem
was, but I got my script to work by using
foreach tablespace {
get list of datafiles
begin backup mode
call separate script to do fancy file copying with forks and children
end backup mode}
rather than putting all the fanc
ind typos in variable names.
A must for anything over 10 or 20 lines or so.
-Original Message-
From: Laurie Gennari [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 22, 2001 2:12 PM
To: Dbi-Users (E-mail)
Subject: RE: using statement handle in a loop
Hmmm... I tried moving the prepare ou
Hmmm... I tried moving the prepare out of the loop AND using
getDFhandle->finish, and I still get an error. This time, the execute fails
(rather than the prepare). Very odd
Tried use strict, but all it told me was to put package names in front of
every single solitary thing, so I turned it of
lem. You should
also consider making your program work using 'use strict;'
and 'use warnings;' (or '-w').
-Original Message-
From: Laurie Gennari [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 22, 2001 12:15 PM
To: Dbi-Users (E-mail)
Subject: using statemen
I'm looping on a list of tablespaces like so:
foreach $tsName (@tablespaces) {
$getDFsql = "select file_name
from dba_data_files
where tablespace_name = ?";
$getDFhandle = $dbh->prepare($getDFsql);
$getDFhandle->execute($tsName)
|| die "Can't
