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
Does DBD-Oracle 1.13 support Oracle 9.2.0? If not, are there any
alternatives I could entertain?
Any information is appreciated,
Mike
Do you have a version of DBD::Oracle that works with Oracle 9i databases?
Thanks,
Jason
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 futzing with it.
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
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 probably
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::MkTemp, or
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 need to
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 again?
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
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 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,
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
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
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
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
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
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
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
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 25
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
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 =
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',
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
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
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 `built-in', needed by `miniperlmain.o'.
Stop.
Anyone seen this?
Lincoln, yes, I had to use
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
--- 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 `built-in', needed by
`miniperlmain.o'.
Stop.
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
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
perl code
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
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:
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 manual
33 matches
Mail list logo