Thanks for the info.
Anyone ever got perl working against 9.2 and was able to connect with
7.3.4 still? Cause we are using 3 versions atm : 7.3.4 8.1.7 and 9.0.1 (
planning on make them all 9.2 )
Kind regards
-Original Message-
From: Chris R. Donnelly [mailto:[EMAIL PROTECTED]
Sent: d
On Mon, 24 Mar 2003, Casella, Richard A wrote:
> I am having a problem getting this to work and the documentation
> I have found doesn't seem to be helping, hopefully someone out there
> can help me.
>
> I am using MySQL 4.01-Gamma on a Debian Linux box. I have configured
> MySQL exactly as the m
Are you using a single-quoted or double-quoted string? Remember that Perl
will evaluate arrays in double-quoted strings, so it is likely that is
happening... do you not have strict vars turned on or have a variable named
@remote?
DBD::Oracle uses OCI calls directly (just as SQL*Plus does) and def
I found that this works for me when I pass the database link as a variable.
INSERT INTO [EMAIL PROTECTED]
SELECT * FROM foo
WHERE condition='bar';
>
> --- "Chen, Allen" <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > I've searched all over and can't seem to find an answer to this...
> > I have
>
I'm sure Tim Bunce will have a more definitive answer, but one way to
get around this is to create a synonym for the [EMAIL PROTECTED] table.
i.e. create synonym foo_remote for [EMAIL PROTECTED];
and then you can run your sql as such:
insert into foo_remote
select * from foo
whe
--- Thomas Good <[EMAIL PROTECTED]> wrote:
> On Tue, 25 Mar 2003, Lincoln Stein wrote:
>
> > Oddly enough, installing Perl 5.8 from source on a virgin RedHat
> 8.0 system
> > fails with this mysterious error:
> >
> > make: *** No rule to make target `', needed by
> `miniperlmain.o'.
> > S
Hi,
I've searched all over and can't seem to find an answer to this... I have
perl code using DBI and DBD::Oracle where I'm trying to selectively copy
rows from one table to another table on a remote database via an Oracle
database link. The SQL is pretty simple and basically looks like the
foll
On Tue, 25 Mar 2003, Lincoln Stein wrote:
> Is this a Perl problem, a make problem, or a RedHat problem?
>
> Lincoln
Lincoln,
I thought it was a perl problem as when I googled for the err string
I got back several examples of how to workaround it. But then I built
the src on slackware and I did
On Tue, 25 Mar 2003, Lincoln Stein wrote:
> Oddly enough, installing Perl 5.8 from source on a virgin RedHat 8.0 system
> fails with this mysterious error:
>
> make: *** No rule to make target `', needed by `miniperlmain.o'.
> Stop.
>
> Anyone seen this?
Lincoln, yes, I had to use se
We are encountering a similar issue at our company, but it seems to be
very specific in what it is affecting. Whenever we build
DBI/DBD::Oracle against Oracle 9.2 on either Linux or Solaris (32-bit; I
did the trick you mentioned), it connects and is able to select from
local tables, but against an
Setting LongReadLen to 64000 had no effect - exact same problem. I am
running DBD::Oracle 1.13, and here's the result of the test:
pink:/home/miller/.cpan/build/DBD-Oracle-1.13> setenv ORACLE_USERID
scott/[EMAIL PROTECTED]
pink:/home/miller/.cpan/build/DBD-Oracle-1.13> make test
PERL_DL_NONLAZY=1
A bit more information. I'm wondering if something is broken with my perl
installation. Here's a sample program I wrote to test out the fetching of
longs from the sessions table:
#!/usr/local/bin/perl -w
use strict;
use DBI;
my $dbh = DBI->connect( 'dbi:Oracle:SSS', 'websec', 'websec',
On Tue, 2003-03-25 at 01:50, [EMAIL PROTECTED] wrote:
> Hi Michael
>
> >> The issue is that trailing whitespace has been truncated
> >> from the last output.
>
> >> When the same SQL is run using isql, the output is as expected.
> >> So, this appears to be an issue either with DBI or with DBD::Sy
I'm running ActiveState perl 5.8.0 on a WIN2K box with MS SQL Server 2000.
Recently I updated DBD-ODBC to v1.05 and DBI to v1.35
Now I get the following errors executing some sql commands
CREATE SQLSTMT:[CREATE DATABASE POMS_SER ON (NAME = 'POMS_SER_DAT', FILENAME =
'd:\Database\POMS\POMS_SER_D
I'm not familiar with DBD::mysqlPP - this is an open question to
anyone who is - are placeholders supported in DBD::mysqlPP?
If placeholders are supported, then they should be used - many
reasons to use them, and no reasons not to. They remove all
quoting issues, and increase performance in many
On Tue, Mar 25, 2003 at 09:55:40AM -0700, Ken Miller wrote:
> I've got a strange problem with Apache::Session, and DBD::Oracle:
>
> [Tue Mar 25 10:01:03 2003] [error] Invoking view: /security/list-users.html
> --> DBH LONG READ LEN: 256000 <--
> --> STATEMENT LONG READ LEN: 256000 <--
> [Tue Mar 2
On Tue, Mar 25, 2003 at 05:51:01PM +0100, [EMAIL PROTECTED] wrote:
>
> Errr... why the rapid new releases all of a sudden ?
Errr... well I could take an 18 month break from DBD::Oracle
development again, if you'd like :)
Or else I could work towards addressing at least the main
build / perl vers
I've got a strange problem with Apache::Session, and DBD::Oracle:
[Tue Mar 25 10:01:03 2003] [error] Invoking view: /security/list-users.html
--> DBH LONG READ LEN: 256000 <--
--> STATEMENT LONG READ LEN: 256000 <--
[Tue Mar 25 10:01:05 2003] [error] Error trying to access session:
DBD::Oracle::st
Errr... why the rapid new releases all of a sudden ?
Besides, you only need to changed those entries to lib32 if you don't have a
64bit perl build. I did succeed building a 64bit perl and get it to work
with a DBD built versus standard Oracle 9.2.0.2 on a HPUX 11i system. Worked
fine. The trouble
Or wait a day or so till DBD::Oracle 1.14 is out.
Tim.
On Tue, Mar 25, 2003 at 10:41:03AM -0500, [EMAIL PROTECTED] wrote:
> To build with Oracle 9.x and the current version of DBD-Oracle. You care
> going to have to hack the generated Makefile to change all the Oracle
> library paths from lib to
Hi,
Just quote it :)
my $qname= $dbh->quote("$Name $Surnames[$idx]");
Then use as query:
SELECT username, dayofyear(startdate),
dayofyear(enddate),dayofyear(enddate) -
dayofyear(startdate)+1 , absencetype
FROM `absence`
where username = $qname
order by absencetype
Assuming $dbh is your
I'm trying to build a dynamic piece of code that generates a HTML view like a year
planner for all employees in the company all on one page. My appraoch is to use 2
Quesries, the first getting all the active employee names and the second then
determines the dates of absence and plot that on a 36
To build with Oracle 9.x and the current version of DBD-Oracle. You care
going to have to hack the generated Makefile to change all the Oracle
library paths from lib to lib32. And to run you are going to have to update
your SHLIB_PATH to point to $ORACLE_HOME/lib32.
Lincoln
-Original Messa
On Mon, 24 Mar 2003 20:28:41 -0500 "DeCorte, Jason - NASHCCON" <[EMAIL PROTECTED]>
wrote:
> Do you have a version of DBD::Oracle that works with Oracle 9i databases?
Yes. The usual one. See http://xmlproj.com/fom-serve/cache/61.html .
If a pre-compiled binary isn't available for your platform
On Mon, 24 Mar 2003 19:54:51 -0500 [EMAIL PROTECTED] wrote:
> Does DBD-Oracle 1.13 support Oracle 9.2.0? If not, are there any
> alternatives I could entertain?
Yes. No alternatives that involve DBI.
See "IF YOU HAVE PROBLEMS" in DBI-1.35/README and
DBD-Oracle-1.13/README if you have problems.
On Tue, 25 Mar 2003 09:04:41 +0100 [EMAIL PROTECTED] wrote:
> Currently in a project to convert our existing 7.3.4 and 8.1.7 Databases
> to Oracle9i.( Either the 9.0.1 or 9.2 version ) Now I'm having some
> problems connecting to some test databases I have setup. Do I need to
> upgrade my perl ver
On Tue, Mar 25, 2003 at 09:06:16AM +0100, Salvatore Sorrentino wrote:
> Thanks for your answer.
> I upgraded to DBD::Oracle 1.13 then I tried again.
> This time things seems better but nevertheless there is an error:
> ocidfn.h and ociapr.h include files are missing.
> Could you please help me agai
On Tue, Mar 25, 2003 at 09:04:41AM +0100, [EMAIL PROTECTED] wrote:
> Hi all,
>
>
>
> Currently in a project to convert our existing 7.3.4 and 8.1.7 Databases
> to Oracle9i.( Either the 9.0.1 or 9.2 version ) Now I'm having some
> problems connecting to some test databases I have setup. Do I nee
On Tue, 25 Mar 2003 00:53:16 -0500, Scott R. Godin wrote:
>Ron Savage wrote:
Hi Scott
>>On Sun, 23 Mar 2003 16:37:43 -0500, Scott R. Godin wrote:
>>>Ron Savage wrote:
>>
>>Hi Scott
>>
>>>Yes, unfortunately there's no default $ENV{TEMP} on unix..
>>>
>>>I've been considering using File::Temp, File
Hi Michael
>> The issue is that trailing whitespace has been truncated
>> from the last output.
>> When the same SQL is run using isql, the output is as expected.
>> So, this appears to be an issue either with DBI or with DBD::Sybase.
> This isn't DBI, and it isn't DBD::Sybase. The last query pr
Thanks for your answer.
I upgraded to DBD::Oracle 1.13 then I tried again.
This time things seems better but nevertheless there is an error:
ocidfn.h and ociapr.h include files are missing.
Could you please help me again?
Thank you very much in advance!
Salvatore Sorrentino
bash-2.05a# perl Makef
Ron Savage wrote:
> On Sun, 23 Mar 2003 16:37:43 -0500, Scott R. Godin wrote:
>>Ron Savage wrote:
>
> Hi Scott
>
>>Yes, unfortunately there's no default $ENV{TEMP} on unix..
>>
>>I've been considering using File::Temp, File::MkTemp, or IO::File
>>instead,
>>but just haven't gotten around to futz
Do you have a version of DBD::Oracle that works with Oracle 9i databases?
Thanks,
Jason
Does DBD-Oracle 1.13 support Oracle 9.2.0? If not, are there any
alternatives I could entertain?
Any information is appreciated,
Mike
Hi all,
Currently in a project to convert our existing 7.3.4 and 8.1.7 Databases
to Oracle9i.( Either the 9.0.1 or 9.2 version ) Now I'm having some
problems connecting to some test databases I have setup. Do I need to
upgrade my perl version or Dbi / DBD version to be able to connect? I
keep g
35 matches
Mail list logo