Here's a fun and slightly obfuscated method to do that:
my $usql=q{select username from dba_users};
my $aryRef = $dbh-selectall_arrayref($usql);
my @users = map { $aryRef-[$_][0] } 0..$#{$aryRef};
my $newSql = q{select from users where username in ('}
. join(q{','},@users) . q{')};
print
I am using the DeveloperSide.net installation of Apache2/ModPerl2 which
requires that I build modules manually rather than using PPM.
I was able to get it installed on my Win2k desktop after copying files like
(nmake,cl,etc) to a directory in my path. But I can't get it installed on a
Win2k
Thanks for the info. The list of search locations is now:
# --- Oracle Instant Client locations
$OH/sdk, # Instant Client default location (10g)
/include/oracle/$client_version_full/client, # Instant Client for
RedHat FC3
# --- Traditional full-install locations
I am trying to set the
LongReadLen value of $dbh dynamically to select a CLOB,
using:
$dbh-{LongReadLen}
= $dbh-selectrow_array(qq{ SELECT
MAX(mc.mc_long_description)
FROM dmg.maint_codes mc
});
but get this error
DBD::Oracle::db selectrow_array failed: ORA-00932:
Jared Still [mailto:[EMAIL PROTECTED] wrote:
Here's a fun and slightly obfuscated method to do that:
my $usql=q{select username from dba_users};
my $aryRef = $dbh-selectall_arrayref($usql);
my @users = map { $aryRef-[$_][0] } 0..$#{$aryRef};
my $newSql = q{select from users where username
I am not totally sure that is the issue. Using sqlplus and TOAD to just
do the simple select
SELECT MAX(mc.MC_LONG_DESCRIPTION)
FROM dmg.MAINT_CODES mc
comes back with inconsistent datatypes.
BTW, the I pulled the dbh statement from perldoc DBI under the
LongReadLen section.
On Thu, 2005-05-26 at 07:05, Ronald J Kimball wrote:
Regardless of the method you use to construct the query, you should not
quote the values by hand. This approach will fail if a value contains a
single quote, and may make you vulnerable to SQL injection attacks.
Yes, thank you. A bad
A little RTFM is in order.
Try max(dbms_lob.getlength(mc.mc_long_description))
Jared
On Thu, 2005-05-26 at 07:27, Tantalo, Christopher G wrote:
I am not totally sure that is the issue. Using sqlplus and TOAD to just
do the simple select
SELECT MAX(mc.MC_LONG_DESCRIPTION)
FROM
Which manual did you FR this from?
---
Just Your Friendly Neighborhood
_SPIDEY_
-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 26, 2005 10:48 AM
To: Tantalo, Christopher G
Cc: Chuck Fox; DBI List
Application Developer's Guide - Large Objects (LOBs)
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Tantalo, Christopher G [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 26, 2005 8:57 AM
To: Jared Still
Cc: DBI List
Subject: RE: LongReadLen issue
Has anyone used DBI in an Oracle 9i RAC configuration on Linux? If
so, were there any issues moving to RAC?
--
Steve Sapovits[EMAIL PROTECTED]
No issues. We are using oracle 9i and 10g rac with dbi on sparc solaris
and linux respectively.
Date: Thu, 26 May 2005 12:09:36 -0400
From: Steve Sapovits [EMAIL PROTECTED]
To: dbi-users@perl.org
Subject: Oracle 9i RAC on Linux
Has anyone used DBI in an Oracle 9i RAC configuration on
Hi all
I have a problem with java application.
My shell script uses some jar files and calls a class
I have set up the DBAccessor.properties with
driver=COM.ibm.db2.jdbc.app.DB2Driver
# specify connection url
url=jdbc:db2:dev_cms
But iam getting SQL Problems : No suitable driver
I use it -- no problems -- the libclntsh is basically the same.
Your only difference is really your tnsnames.ora -- you may want to load
balance and use TAF against your RAC servers.
BN
Steve Sapovits wrote:
Has anyone used DBI in an Oracle 9i RAC configuration on Linux? If
so, were
This is not the mailing list you're looking for. This mailing list is
specifically about using the Perl DBI with the associated database
drivers (for example, the DBD::DB2 driver, as documented at
http://ibm.com/db2/perl/).
If you want help calling Java applications from a shell script, you
would
I am sorry if this is covered somewhere that I have been unable to find
it. I have not been able to connect to the FAQ at
http://dev.isystek.com/dbi/fom.cgi. The only faq's I have found on-line
are dated CY2000, and do not appear to address this issue.
I am a UNIX admin, supporting a large
while placeholders are better than literals, you will still end up with
potentially hundreds of varieties of this sql depending on the varying number
of placeholders used. If you always have the same number or approximately the
same number of placeholders, than a series of placeholders with a
JK,
I have faced this very problem. I solved this as follows:
1. Compile DBD::Oracle using the $ORACLE_HOME of the highest installed version
of Oracle.
2. Add an entry to /etc/oratab: dbi-home:/path/to/latest/oracle/install:N
3. Ensure this ORACLE_HOME's environment variables are set prior
Use a global temporary table to store the results and join the GTT in the
select. No bind variables, no problem with quoting, very easy.
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Job Miller [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 26,
19 matches
Mail list logo