[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 for split /;/.
Sqlplus has its own little language, with a grammar
: [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:
- who controls the source code that is the input to your module?
- what control do you have over them?
- what do you _really_
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
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
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))
/