CTED]
> > Sent: Thursday, February 27, 2003 10:16 AM
> > To: Fernando Luna
> > Cc: [EMAIL PROTECTED]
> > Subject: RE: Running SQL from files - was: Your DBI book
> > I suggest you step way back and ask yourself various key questions,
> > such as:
> >
> >
age-
> From: M Addlework [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 27, 2003 10:16 AM
> To: Fernando Luna
> Cc: [EMAIL PROTECTED]
> Subject: RE: Running SQL from files - was: Your DBI book
>
>
> Fernando,
>
> It's very naive to view this is just a task
Fernando,
It's very naive to view this is just a task for "split /;/".
Sqlplus has its own little language, with a grammar and
sytntax, variable substitution, etc. Consider this sqlplus
script:
@defines
whenever sqlerror exit failure
create table &&prefix._snafu(col varchar2(10))
Fernando Luna wrote:
Fernando Luna wrote:
[...]
I am running perl version 5.005_03 built for AIX Unix.
Get ready to upgrade.
So, is this version not stable enough for me to do what I want? Why
should I worry about upgrading right now?
It's stable - but note that the release notes for DBI 1.33 say
The only problem I see with the approach of stripping out semi-colons before passing
DDL statements to Oracle is that CREATE PACKAGE statements have semi-colons all over
the place... in fact, you can't have a PACKAGE Specification and body without the
semi-colons which terminate each statement i
: Jeff Zucker [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 27, 2003 8:36 AM
> To: Fernando Luna
> Cc: [EMAIL PROTECTED]
> Subject: Re: Running SQL from files - was: Your DBI book
>
>
> Fernando Luna wrote:
>
> >>>What I'd like to do is read a file
Fernando Luna wrote:
What I'd like to do is read a file that contains DDL
statements and execute them through these modules.
Most of my test scripts use the following format for DDL and it will
work just as well with file data:
$dbh->do($_) for split /;\n/, join('', );
__DATA__
DROP T
Tell IBM/Bull that ..
-Original Message-
From: Jonathan Leffler [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 27, 2003 1:55 PM
To: Fernando Luna
Cc: [EMAIL PROTECTED]
Subject: Re: Running SQL from files - was: Your DBI book
Fernando Luna wrote:
> [...]
>
>
>
> Fernando Luna wrote:
> > [...]
> > I am running perl version 5.005_03 built for AIX Unix.
>
> Get ready to upgrade.
>
So, is this version not stable enough for me to do what I want? Why should I worry
about upgrading right now?
> > I have Oracle version 8.1.7 installed and running.
> >
Fernando Luna wrote:
[...]
I am running perl version 5.005_03 built for AIX Unix.
Get ready to upgrade.
I have Oracle version 8.1.7 installed and running.
I have AIX version 4.3.3.0
[...] I am able to
execute queries and PL/SQL blocks using these modules with no
problems. What I'd like to do is
10 matches
Mail list logo
