On Wednesday 24 May 2006 22:11, mark wrote:
ravi kongara wrote:
But it is little surprising that dbi doesn't support executing sql files
directly.
What you are calling sql file is actually an *Oracle SQLPlus file*.
Maybe DBD::Oracle could have a SQLPlus emulation mode, but even if
such a
mark wrote:
ravi kongara wrote:
But it is little surprising that dbi doesn't support executing sql
files directly.
What you are calling sql file is actually an *Oracle SQLPlus file*.
I just read about SQL::Library in O'Reilly's new Perl Hacks book (Hack
23. Build a SQL Library). I haven't
utility are truly glue type utilities that
can help keep legacy apps from being rewritten.
rr
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 24, 2006 3:15 PM
To: Job Miller
Cc: DBI-Users
Subject: Re: how to invoke .sql file from dbi
Hi Miller
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 23, 2006 2:40 PM
To: DBI-Users
Subject: how to invoke .sql file from dbi
Hello all,
We have bunch of sql files ( .sql ) that we want to invoke from dbi (
Oracle ). How does it work. Dbi expects
use Expect;
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 23, 2006 12:40 PM
To: DBI-Users
Subject: how to invoke .sql file from dbi
Hello all,
We have bunch of sql files ( .sql ) that we want to invoke from dbi (
Oracle ).
How does it work.
, Philip (MAN-Corporate)
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 24, 2006 7:12 AM
To: DBI-Users
Subject: RE: how to invoke .sql file from dbi
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 23, 2006 2:40 PM
To: DBI-Users
Subject: how to invoke
Hi Miller,
The sql statements are SELECT statements and we are expecting plain ( no
formatting required) output from these statements.
They are static and expect input values for substitution.
Yes, i thought over converting all sqls to pl/sql but it is a overkill
for us.
Currently i sticked
ravi kongara wrote:
But it is little surprising that dbi doesn't support executing sql files
directly.
What you are calling sql file is actually an *Oracle SQLPlus file*.
Maybe DBD::Oracle could have a SQLPlus emulation mode, but even if
such a beast existed, it would certainly not be part of