On Sun, 11 Mar 2001, MikeBlezien wrote:
..
> This maybe more of a MySQL question than DBI, but I have a Perl script
> that does 4 INSERTS into various tables. I know MySQL doesn't support
> Transactions, but when the data is inserted into the tables and during
> the process a error is encountered
It depends on the database engine, but I know for certain that Oracle
connections react badly to being used in a child after being created in the
parent. Most other databases probably will too.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a
It appears that selecting @@IDENTITY returns only the first IDENTITY
result for the database connection. This is with SyBase 11.0.3.3, DBI
1.13 and DBD:Sybase 0.91.
For example, I created a test table as such:
create table test (id numeric(10,0) identity, blah char(10) null)
And then ran a Perl
After something that happened in my code recently, I suspect there may be a
more general problem. May I suggest you replace the prepare/executes with
the basic 'do' function for the two insertions. Does this make any
difference?
My problems involved a rather long-winded trigger, which (among ot
Eric Kolve writes:
> Is it possible to share a database handle initialized in a parent with
> forked children ? What I want to do is process a file which needs to
> execute many SELECT statements in parallel. I am wondering if each
> child needs to instantiate its own dbh or whether you can
Andrew Powell writes:
> It appears that selecting @@IDENTITY returns only the first IDENTITY
> result for the database connection. This is with SyBase 11.0.3.3, DBI
> 1.13 and DBD:Sybase 0.91.
>
> For example, I created a test table as such:
> create table test (id numeric(10,0) identity,
Hi !
I like to connect from my Linux to a remote Oracle DB, what is running on Solaris.
I downloaded and unzipped the DBI-1.14. I made succesfully the "perl Makefile.PL"
step,
but when a tried to run the "make" command I received the next:
cc -c -Dbool=char -DHAS_BOOL -I/usr/local/include -O2
Michael:
WOW! NEAT! THANKS!! That solved the problem.
Sincerely,
Andrew Powell
aap
Michael Peppler wrote:
> Andrew Powell writes:
> > It appears that selecting @@IDENTITY returns only the first IDENTITY
> > result for the database connection. This is with SyBase 11.0.3.3, DBI
> > 1.13
What is ACID?
What is the BDB table type?
> -Original Message-
> From: Stephen Clouse [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, March 11, 2001 9:30 PM
> To: MikeBlezien
> Cc: [EMAIL PROTECTED]
> Subject: Re: RollBacks
>
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On Sun, Mar
From: "David Armstrong" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject:request help internet tcp to DBI-mysql
Date sent: Thu, 8 Mar 2001 16:41:11 -
Hi Dave,
I am only a hobbyist, but see below...
> Could i please ask
I have no problem connecting to an Oracle 8.1.5 database on Netware 5.1 and
viewing the contents of the database, however, add or editing are causing me
problems.
Here is my test code:
#!c:\perl\bin\perl.exe
use CGI;
use DBI qw(:sql_types);
$query = CGI::new();
if (($query->request_method() eq
Do you have some date data types in your db which are used in the insert?
If yes you need to use to_date() sql function in your query.
To format the date/hours.
Ilya Sterin
-Original Message-
From: Mitch Clarvit
To: [EMAIL PROTECTED]
Sent: 3/12/01 11:33 AM
Subject: Connecting to An Orac
Receiver, InterScan has detected virus(es) in the e-mail attachment.
Date: Tue, 13 Mar 2001 09:24:48 +1100 (AUS Eastern Daylight Time)
Method: Mail
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
File: 'Community' VALUE=$community>"; print ""; print "";
print "
Tim Harsch ([EMAIL PROTECTED]) wrote:
> What is ACID?
>From http://openacs.org/philosophy/why-not-mysql.html (I highly
recommend this article for anyone who is wondering what RDBMS
to choose):
Atomicity
Results of a transaction's execution are either all
committed
In case you weren't already planning to, you'll probably also
want to wrap your original query in an eval block to trap any errors.
Then use the suggestions below to undo any incomplete "transactions".
This will also help prevent any other errors that might creep in
between inserts/updates from l
Hi All,
Can someone please tell me what this is all about?
DBD::Oracle::st execute failed: ORA-01036: illegal variable name/number (DBD
ERROR: OCIBindByName) at sma_run_aggs.pl line 172.
Here is my syntax:
foreach $tableName (@tableList) {
print STDERR "\n\nDropping indexes (${
Peter,
My guess is that you need comma's between the arguments of a procedure/function
:
$sth = $dbh->prepare("BEGIN $DICEpackage.DROP_INDEXES(:1:2:3); END;");
should be :
$sth = $dbh->prepare("BEGIN $DICEpackage.DROP_INDEXES(:1, :2, :3);
END;");
Brgds,
Mark
"Loo, Peter # PHX"
Mark,
I tried it with commas also and it gave me the same error message. I tried
using the bind also and not successful.
Peter
-Original Message-
From: Mark Vandenbroeck [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 12, 2001 4:40 PM
To: Loo, Peter # PHX
Cc: '[EMAIL PROTECTED]'
Subjec
Sounds like it doesn't like :1 :2 :3 for some reason. What version of
DBD::Oracle are you using. Try with ?, ?, ? instead and see if that works.
Ilya Sterin
-Original Message-
From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 12, 2001 6:59 PM
To: 'Mark Vandenbroeck'
How do you check for a correct version? I am seeing all sort of information
with different values.
-Original Message-
From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 12, 2001 5:14 PM
To: Loo, Peter # PHX; 'Mark Vandenbroeck'
Cc: [EMAIL PROTECTED]
Subject: RE: Stored Pr
Forgot how to do the easy way, but just print out the
$DBD::Oracle::VERSION
Did it work with '?' instead of ':1'
Ilya Sterin
-Original Message-
From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 12, 2001 7:27 PM
To: 'Sterin, Ilya'; Loo, Peter # PHX; 'Mark Vandenbroec
Hi Ilya,
No it is not working with '?' either. Nothing is print out for:
#!/usr/bin/perl
use DBI;
print "$DBD::Oracle::VERSION\n";
exit;
-Original Message-
From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 12, 2001 5:38 PM
To: Loo, Peter # PHX; 'Mark Vandenbroeck'
C
Ilya,
Here it is:
# $Id: Oracle.pm,v 1.76 1999/06/14 00:41:48 timbo Exp $
#
# Copyright (c) 1994,1995,1996,1997,1998,1999 Tim Bunce
#
# You may distribute under the terms of either the GNU General Public
# License or the Artistic License, as specified in the Perl README file,
# with
"Tim Harsch" <[EMAIL PROTECTED]> wrote:
> What is the BDB table type?
Since the ACID question has been answered, I thought I'd
give you an answer on the "BDB" table type. I'm not
going to bother being diplomatic here, so you'll have to
take it as a given that I'm a mysql-hater, and try and
com
1. What is the value in $DICEpackage?
2. You should call $dbh->prepare() outside the loop. Keep both prepared
handles in separate variables.
3. The bind variables (:1, :2, :3) definitely need to be separated by commas
(,) in both SQL statements.
4. You don't need either the quotes or braces in th
Hi Michael,
1) $DICEpackage is a store procedure we use internally.
2) The reason that $dbh->prepare is in loop to dynamically handle multiple
tables.
3) I have tried bind variables with commas and yet it didn't work.
4) {} is a style I had adopted to identify that a variable was previously
decl
26 matches
Mail list logo