Lethal Possum wrote:
On Jun 5, 6:52 pm, listm...@triad.rr.com (listmail) wrote:
Lethal Possum wrote:
Hello,
I am trying to create a prepared statement for the following query in
MySQL:
INSERT IGNORE INTO foo (group, value) (SELECT 101, value FROM bar
WHERE value LIKE
Lethal Possum wrote:
Hello,
I am trying to create a prepared statement for the following query in
MySQL:
INSERT IGNORE INTO foo (group, value) (SELECT 101, value FROM bar
WHERE value LIKE '%something%');
So far my Perl code looks something like this:
my $group = 101;
my $pattern = '%something
Serguei wrote:
Dear Experts,
I have a Perl application which works fine at Solaris UNIX box with
Perl 5.6.1 and the Oracle 9i database. Now our team is moving to the
Oracle 11g database and I have a problem. I changed $PATH,
$ORACLE_HOME and $LD_LIBRARY_PATH variables to point to new Oracle 11
I haven't ran x86 in a long time. I don't know why the situation would
be different and allow you to change LD_LIBRARY_PATH after perl starts
though. Is it possible that derived defaults are being used rather than
your change? I imagine you also have to take in to account whether you
are usi
Bruce Ferrell wrote:
Alexander Foken wrote:
On 13.05.2009 02:59, Brian Manning wrote:
Can you tell me why I'm getting this error:
DBD::mysql::st execute failed: Can't create/write to file
'/tmp/result.csv' (Errcode: 2)
You don't have create/write permissions to the /tmp
Koester, Chris wrote:
Scripts ran from cron give this error.
failed: ERROR OCIEnvNlsCreate. Check ORACLE_HOME (Linux) env var or PATH
(Windows) and or NLS settings, permissions, etc. at
/app/XOstats/prod/bin/util/check_user.pl line 43
Can't call method "disconnect" on an undefined value at
/
Or at least keep a complete oracle export on hand in case your final
plans fall through and you need to
play hero by recreating the old database.
Jeffrey Seger wrote:
Is this a business critical database? If so, I would go back to the
business and make an argument that the current database not
Pushing this response to the list for Alejandro and whoever else.
Original Message
Subject:Re: DBD::Oracle installation problems
Date: Sun, 18 May 2008 15:27:45 -0400 (EDT)
From: [EMAIL PROTECTED]
To: listmail <[EMAIL PROTECTED]>
References: <[EMAIL
Alejandro Santillan Iturres wrote:
I am root. I've installed on a RH enterprise the following RPM's:
oracle-instantclient-basic-11.1.0.1-1.i386.rpm
oracle-instantclient-devel-11.1.0.1-1.i386.rpm
oracle-instantclient-jdbc-11.1.0.1-1.i386.rpm
oracle-instantclient-sqlplus-11.1.0.1-1.i386.rpm
which
t generated the
Oracle.so file...
John Scoles wrote:
What exactly did you remove?
- Original Message - From: "listmail" <[EMAIL PROTECTED]>
To:
Sent: Friday, October 13, 2006 1:41 PM
Subject: [Fwd: compiling DBD-Oracle 1.16 against an Oracle 9i 64bit home]
I simply
06 13:09:02 -0400
From: listmail <[EMAIL PROTECTED]>
To: dbi-users@perl.org
I'm trying to compile DBD-Oracle 1.16 against an Oracle 9i 64-bit home
and got a little further this time when I set LD_LIBRARY_PATH to include
$ORACLE_HOME/lib32. I'm not seeing what file it canno
I'm trying to compile DBD-Oracle 1.16 against an Oracle 9i 64-bit home
and got a little further this time when I set LD_LIBRARY_PATH to include
$ORACLE_HOME/lib32. I'm not seeing what file it cannot find and the
three .0 files were created. The following is the output of env vars,
the "perl M
There's some sys DBMS packages that you can have the perl program call
and update the MODULE, ACTION, etc columns to make it easier to identify
your program if needed. I'm not a my work desk nor do I aim to memorize
these things so I cannot be specific. Generally you see perl.exe
though at l
ma, Inc.
-Original Message-
From: listmail [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 27, 2005 12:36 PM
To: dbi-users@perl.org
Subject: desc: invalid sql statement
I believe a describe statement is Oracle DDL, but I still failed for
both of the ways that I know of to execute sql.
I believe a describe statement is Oracle DDL, but I still failed for
both of the ways that I know of to execute sql. There must be something
that I am not considering.
#!/usr/local/bin/perl
#script to demonstate execution failure
use strict;
use warnings;
use DBI;
use DBD::Oracle;
my $userna
ince me as well. I only recently installed the
client and put the 8.1.7 at the recommendation of our Oracle DBA, but
don't know why he recommended that.
Thanks for the response.
L
-Original Message-
From: listmail [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 22, 2005 8:
installed and the following:
Windows Server 2003
ActivePerl 5.8.7 build 813
DBI 1.49
DBD-Oracle 1.16
BTW, is anyone else having issues with PPM? Seems like the last few
releases have had bugs it's getting frustrating?
L
***
oracle OCI.dll NLS error on connect
listmail
Mon,
> which ultimately makes the
> 50 or
> 60 line script you sent originally about 10 lines or less. (IE by
> using
> the array of array setup instead of some convoluted matrix that is
> structured god know how.
>
> That means in six months when you (or heaven forbid me) have to
> maintain
> y
Well I'm not seeing why a number of arrays that each point to arrays
could not be consider a matrix of arrays when considering one definition
of the word matrix "Something resembling such an array, as in the
regular formation of elements into columns and rows". I dunno, i'm not
trying to argue
> [EMAIL PROTECTED] wrote:
>
> > #Here's an example which shows what I am trying to accomplish.
> If I
> > can determine the number of rows before pushing the data, this
> can
> > simply things for #me when processing the data throught my
> scripts.
> > #
> > use warnings;
> > use strict;
#Here's an example which shows what I am trying to accomplish. If I
can determine the number of rows before pushing the data, this can
simply things for #me when processing the data throught my scripts.
#
use warnings;
use strict;
use DBI;
use DBD::Oracle;
my $sql=q{ select name, location
I get the following error when connecting to an 8i oracle database from
workstations with the Oracle 8i client installed or if their Oracle
Home selector is set to the 8i home. If the workstations only have the
Oracle 9i client installed or if the Oracle Home selector is set to
the 9i home, t
22 matches
Mail list logo
