If you are using DBI::SQL_INTEGER, ':sql_types' needs to be imported,
i.e.
use DBI qw(:sql_types);
On Sun, 2005-12-11 at 18:45 -0500, Patrick Danley wrote:
I am new to DBI, Perl, and SQL and I am currently trying to piece
together a group of bioinformatic programs. In running the
Jeffrey == Jeffrey Seger [EMAIL PROTECTED] writes:
Jeffrey Is $ORACLE_HOME set to the correct path?
Now it is.
Jeffrey If the tnsnames.ora is not in $ORACLE_HOME/network/admin/, is
Jeffrey $TNS_ADMIN set to the actual location of the file?
Jeffrey On 09 Dec 2005 15:37:33 +0200, Claude [EMAIL
Ron == Ron Reidy [EMAIL PROTECTED] writes:
Ron Can you connect to this database using SQL*Plus in the same manner?
Ron From the error docs:
Ron $ oerr ora 12154
Ron 12154, 0, TNS:could not resolve service name
Ron // *Cause: The service name specified is not defined correctly in the
Ron //
I'm guessing not. I see an error and I'm guessing that it detects the
column type is not correct. Can you set DBI-trace to 9 and send me the
output?
Jeff
-Original Message-
From: yongming [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 06, 2005 9:36 PM
To: [EMAIL PROTECTED]
Subject:
John wrote:
Can anyone see the error in the following code. It has to do with the
placeholder in the select statement. Substitution fails to occur at
the $sth1-execute... statement script dies at while (my
$rowref If I replace the placeholder with a literal it works as
expected.
Hi,
I'm writing a program that uses DBI/Mysql and does a
*lot* of selects and inserts/updates. (One short run
did 2809 and 5714 respectively).
I've used Devel::DProf with it - in an attempt to get
an idea of any performance problems - and am getting
some interesting data on test runs. One thing
Has anyone got any experience with Apache::DBI::Cache that they might
like to share?
Tim.
http://search.cpan.org/~opi/Apache-DBI-Cache/
http://search.cpan.org/src/TIMB/DBI_AdvancedTalk_2004/sld022.htm
http://search.cpan.org/~timb/DBI/lib/DBI/Profile.pm
Tim.
On Mon, Dec 12, 2005 at 03:03:09PM +, Henry McGuinness wrote:
Hi,
I'm writing a program that uses DBI/Mysql and does a
*lot* of selects and inserts/updates. (One short
Hi,
I start a dbiproxy with the following command. I checked that is
free. My questions are:
- Where does the intriguing port 3209 value below comes from? It is
incremented by 1 at every call of the client. Is it relevant or is
that a well-known problem?
- I could not find the
Capacio, Paula J wrote:
John wrote:
Can anyone see the error in the following code. It has to do with the
placeholder in the select statement. Substitution fails to occur at
the $sth1-execute... statement script dies at while (my
$rowref If I replace the placeholder with a literal it
I take it the real problem is that your query is not returning any data.
Could it be that you're loading @duplist from a file, and it ends with a
newline? Try adding:
chomp $custnum;
before your execute() call.
-Original Message-
From: John [mailto:[EMAIL PROTECTED]
Sent:
Please try issuing another fetchrow_array, if the $sth-err is
SQL-01S01, just to see. It could be that you can safely 'ignore' this
error and use it as a warning.
Jeff
From: Yongming Xu [mailto:[EMAIL PROTECTED]
Sent: Monday, December 12, 2005 4:41 PM
12 matches
Mail list logo