Hi all.
I'm using the process:
my $sth = $dbh->prepare ( "update xxx set a=?, b=?, c=? where d=?" );
$sth->execute( $a, $b, $c, $d );
to update data in a SQL Server database. It works fine most of the time,
but if I have a 'money' column type in SQL Server, I get the following
error:
[unixODBC]
Darren Duncan wrote:
I should emphasize that I never expected to be able to send any type of
ASTs over the pipe to the database. They would still be interpreted by
the database driver for Perl and/or a wrapper thereon, into the database
native format. Its just that, to an application, it woul
BTW: If you need a list of DBD's meeting said requirement, let me know,
I just pulled one down.
Sure, send it over.
[ ] DBD-ADO-2.94.tar.gz 31-Jan-2005 02:4041k GZIP compressed docume>
[ ] DBD-ASAny-1.13.tar.gz 31-Oct-2003 15:0030k GZIP compressed docume>
[ ] DBD-Amazon-
To use -Duse64bitall you would have to build perl (not just the
modules). This is a flag used to build perl.
You can prove that it works by configuring the perl make to build it
rooted in your home dir, like you have the modules. Its really not that
hard.
Once you show it can be done, you can
At 6:30 PM -0700 7/11/05, Dean Arnold wrote:
RE: SQL Parse Trees (or other non-SQL query input)
Since none of (ODBC, JDBC, ADO.NET) seems compelled to
impose this concept on driver writers, I don't see why
DBI should be the vanguard.
I should emphasize that I never expected to be able to send a
RE: Placeholders: since DBIv1 already supports both forms of
PH's, I see no reason to deprecate or abandon either form.
Furthermore, to my knowledge, none of (ODBC, JDBC, ADO.NET)
has abandonded or deprecated the ? form, so I don't see
the need for DBI to.
RE: LOBs and "SQL Parse Trees": having r
A colleague asked for help with the below script.
As I have not worked with 10g and could not find a
relevant FAQ I thought perhaps you gentle folks would
nudge me in the right direction :-)
Jacqui
[EMAIL PROTECTED]:~/tmp$ cat dbi-test.pl
use strict;
use DBI;
#use utf8;
#use bytes;
#use enc
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> I agree. When you get down to it, schema/table/etc reverse
> engineering is a very complicated and involved process. Fetching
> lists of tables or columns etc should no more be built in than SQL
> parsing or generating. In short, anything that c
If I'm reading the DBD::Oracle source code correctly, then it is as you
suggest, it (by default) only allocates one OCI environment at the time of
the first connect, and so OCI only reads NLS_LANG once. This environment is
then shared across all future connections.
Since you just want two connec
Bjorn,
I'm new to this game . I'm not ROOT on the machine, so i compile my modules
to my user's directory.
Does it mean that i have to recomplie the perl on the system (
/usr/bin/perl ) in order to get my module to work ?
or i just need to execute in the module directory :
perl ./Makefile.PL PREFI
On Sat, 2005-07-09 at 12:42 +0200, Jochen Wiedmann wrote:
> Jonathan Leffler wrote:
>
> > I dunno which DBMS support prepare without a database connection, but I
> > would expect all the mainstream databases to require a database connection.
>
> +1
>
> > I'm also far from convinced that there'
You should post this to [EMAIL PROTECTED]
On Sat, 2005-07-09 at 10:36 -0400, Andrew wrote:
> Folks,
> I hope this is correct group.
> I just can't install dbd:oracle on aix . Went though all archives...
> nothing seems to work:
> Here are details :
> 10g 10.2
> This is perl, v5.8.0 built for ai
Rebuild perl with -Duse64bitall flag. There have recent been a number of
problems with this ( it's the same error as some people got with oracle
9i ).
If you don't succeed, i have a document explaining the complete install.
But normally that flag will do the trick.
Ps. Be sure you compile the m
No - you don't seem to understand. The challenge-response protocol can ask
someone for the RSA key fob number this time, their mother's maiden name the
next time, their employee number the time after that, and nothing on the
fourth occasion. You cannot predict what the extra information requeste
Sorry, of course you're right, you can't change character set with alter
session. I've used your technique of setting the environment variable
for nls_lang before and been successful, but I've only been working
with single connections
Martin
Hermann Schwaerzler wrote:
-BEGIN PGP SIGNED
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
hello martin
sorry for the long delay...
Martin Hall wrote:
> Can you use ALTER SESSION and set nls_language?
yes I can, but without the desired effect: changing it to e.g. "GERMAN"
just affects sort order (umlauts), date-format and so on and does n
16 matches
Mail list logo
