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
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, blah
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
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
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
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
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]'
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
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
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
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'
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
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
15 matches
Mail list logo