Hello all,
I am having problems installing Perl DBI using PPM. When I type install DBI
at the PPM prompt I get an error message telling me that it cannot locate
the DBI module.
This is definitely something to do with the settings on my home PC as it
works fine on my office computer.
I am
Okay, this is probably a basic question, but I can't find it. How do you
call a stored procedure in Informix. The stored procedures I want to call
don't return anything, and take zero to two parameters? I have tried to do
a $db-do(execute STOREPROC($arg)) and that gives back a syntax
On Wed, 25 Jun 2003, Christopher Mihaly wrote:
++ Okay, this is probably a basic question, but I can't find it. How do you
++ call a stored procedure in Informix. The stored procedures I want to call
++ don't return anything, and take zero to two parameters? I have tried to do
++ a
On Tue, Jun 24, 2003 at 06:18:41PM -0700, William R Ward wrote:
We recently installed Perl 5.8.0 and have started seeing this error.
I think it's an error in DBI but I'm not 100% sure. Has anyone else
seen this, and what can be done to remedy it?
Use of inherited AUTOLOAD for non-method
Hi,
I found a bug in DBD::mysql 2.1026. I didn't try 2.1027 because,
according to the ChangeLog, it doesn't fix it. My DBI version is 1.30,
MySQL is 4.0.13.
With ShowErrorStatement = 1 the statement in the error message belongs
to the last executed statement, if the actual SQL command is
Hi Anthony
I am having problems installing Perl DBI using PPM. When I type install
DBI
at the PPM prompt I get an error message telling me that it cannot locate
the DBI module.
This is definitely something to do with the settings on my home PC as it
works fine on my office computer.
I
On Wed, 25 Jun 2003, Christopher Mihaly wrote:
++ Okay, this is probably a basic question, but I can't
find it. How
++ do you call a stored procedure in Informix. The stored
procedures I
++ want to call don't return anything, and take zero to two
parameters?
++ I have
On Wed, 25 Jun 2003, Jeff Urlwin wrote:
++ $db-do(execute procedure STOREPROC($arg)) should solve the
++ problem. You missed the word procedure in the execute command.
++
++ That depends upon the database you are using. For Oracle, it would be
++ $db-do(begin STOREPROC($arg); end;);
++
++ Jeff
Thanks all, sorry for the trouble. I think I need to read more clearly
next time.
Chris
--
---
Just Your Friendly Neighborhood
_SPIDEY_
Hardy Merrill wrote:
Ronald J Kimball [EMAIL PROTECTED] wrote:
On Tue, Jun 24, 2003 at 03:42:16PM -0400, Hardy Merrill wrote:
On Tue, 24 Jun 2003 18:42:54 +0100 Robbie Armour [EMAIL PROTECTED] wrote:
I guess so - no special action is required if you store numbers in a
varchar field in MySQL, only text (longtext or mediumtext too).
Also, the same thing works OK with an Oracle long field.
From: Hardy Merrill [EMAIL
On Tue, 24 Jun 2003 12:41:43 -0400 Chang, Mei [EMAIL PROTECTED] wrote:
My program successfully connected to oracle DB and performed all sql
statements, but if I uses perl.exe -w then I got the following
warnings. (Note: the script is still working and executes the sql
statements
hi
SQL Server 2000
windows 2000
perl 5.8
i have an annoying problem with sql server, maybe someone have encountered
something similar - it concerns special (danish) characters that im unable to
insert correctly in the db table (they seem to be escaped with an even stranger
char in the db)
HI,
I am running the Perl DBI interface which connects to a Oracle 8.1.7
database. This all works fine. The problem that I have is that when I
run a particular script ( show below) the dataset that is returned
includes rows from the database that I had deleted prior to running the
script? Any
On Wed, Jun 25, 2003 at 10:04:09AM -0600, Trevor Morrison wrote:
I am running the Perl DBI interface which connects to a Oracle 8.1.7
database. This all works fine. The problem that I have is that when I
run a particular script ( show below) the dataset that is returned
includes rows from
Sorry,
I should have told you that in the original message. Yes, I used sqlplus to delete
the rows in the table (delete from trouble_report;) and I ran a: select * from
trouble_report; --to verify that they were missing and they were. And, no I did not
commit the transaction to delete the
I am using DBI 1.37 and DBD::DB2 .76 with perl version 5.6.1. When my app exits, I
get the following output:
Use of uninitialized value in require at /usr/lib/perl5/5.6.1/AutoLoader.pm line
87 during global destruction.
.
.
.
repeats 20 times.
Any help with where to start looking to track
The autocommit was set to off in my sqlplus. After turning it on it worked like a
charm!
Thanks everyone
Trevor
-Original Message-
From: Fernando Luna [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 10:13 AM
To: Morrison, Trevor (Trevor); Ronald J Kimball
Cc: [EMAIL PROTECTED]
On Wed, 25 Jun 2003 17:36:02 +0200 allan juul [EMAIL PROTECTED] wrote:
SQL Server 2000
windows 2000
perl 5.8
i have an annoying problem with sql server, maybe someone have
encountered something similar - it concerns special (danish)
characters that im unable to insert correctly in the
On Wed, Jun 25, 2003 at 05:37:31AM -0700, Michael A Chase wrote:
On Tue, 24 Jun 2003 18:42:54 +0100 Robbie Armour [EMAIL PROTECTED] wrote:
I guess so - no special action is required if you store numbers in a
varchar field in MySQL, only text (longtext or mediumtext too).
Also, the same
Thanks. Could you retry with DBI 1.37?
Tim.
On Wed, Jun 25, 2003 at 12:25:57PM +0200, Jörn Reder wrote:
Hi,
I found a bug in DBD::mysql 2.1026. I didn't try 2.1027 because,
according to the ChangeLog, it doesn't fix it. My DBI version is 1.30,
MySQL is 4.0.13.
With
Can you post a *small* example that demonstrates the problem?
And/or perhaps also show the relevant part of a DBI trace log
(e.g., set the DBI_TRACE env var to 9=/tmp/dbitrace.log)
Tim.
On Wed, Jun 25, 2003 at 09:24:48AM -0700, Abe Jarrett wrote:
I am using DBI 1.37 and DBD::DB2 .76 with perl
dbitrace.log
I'm working on a pruned down sample which I will send shortly.
dbitrace.log
Description: dbitrace.log
Dear Tanyi (Paul Twa),
Sorry about top-posting this response - blame Lotus Notes.
I don't understand your problem. What do you mean by 'truncated'. Please
provide a complete, self-contained test script that illustrates the problem
on your system, and include the actual output and what you
Hello,
I just upgrades from Oracle 8.1.7.4 to Oracle 9.2.0.1 along with Perl and
DBD and DBI and I have an odd error.
Current Environment (were I am having errors):
Oracle: 9.2.0.1
Perl: 5.8.0
DBD Oracle: 1.14
DBI: 1.37
Old Environment (were the scripts worked):
Oracle:
On Sun, 22 Jun 2003, Robbie Armour wrote:
Hello other DBI Users
I use MySQL text fields as general repositories for code, data etc but find
that numbers are rounded to two decimal places. This does not happen with a
similarly constructed Oracle table - eg
my $c = $dbh-prepare(insert
25 matches
Mail list logo