Hi,
That Makefile.PL still leaves the -l:libcl.a which causes this error:
/usr/bin/ld: Invalid loader fixup in text space needed in output file for
symbol $005C in input file: /usr/lib/libcl.a(ftnerr.o). Make sure it
was compiled with +z/+Z.
Attempting to discover Oracle OCI build rules...
Snowber Khan wrote:
[EMAIL PROTECTED] bugzilla]# perl -MCPAN -e 'force install DBD::mysql'
CPAN: Storable loaded ok
Going to read /root/.cpan/Metadata
Database was generated on Wed, 12 Mar 2003 15:42:32 GMT
Running install for module DBD::mysql
Running make for
Dear sir,
I have a problem with installing the DBI. I get 2 test failed
when I perform make test and make test TEST_VERBOSE=1.
Attached is the
logging message.
Thank you very much for your help.
Regards,
Fujin
test-log
Description: Binary data
I'll be interested in hearing answers from wiser list members, but my
feeling was that 99% of the time tables using an auto-number also had a
unique field elsewhere. So indeed my strategy has always been to do exactly
what you say. If this alternate unique tuple exists, then you don't even
have
Hello,
Does anybody has any script that could give, detailed information about the
performance of an Oracle Database.
regards,
__
Filipe Vasconcelos
Hello,
Does anybody has any script that could give, detailed information about the
performance of an Oracle Database.
regards,
__
Filipe Vasconcelos
On Thu, Mar 13, 2003 at 07:43:17AM -0600, James.FitzGibbon wrote:
There is one outstanding issue that I am aware of. We reported a problem
setting the RootClass
attribute in DBI v1.30, which was addressed in v1.31. Unfortunately, the
fix has a small problem.
Here is the original message
[EMAIL PROTECTED]
Do searches for OraSnap and Oracletool.
OraSnap outputs its reports as html to be viewed in a browser.
Oracletool runs as a web-server cgi script.
-Joe
--- Filipe Vasconcelos [EMAIL PROTECTED] wrote:
Hello,
Does anybody has any script that could give, detailed information
about the
Test received
To: [EMAIL
And the verdict is ... operator error. Sorry for the
wasted bandwidth: stupid mistake on my part.
Good news: I learned a couple of useful things.
Bryan -- would you mind telling me what it was that was causing the
following:
DBD::ODBC::db tables failed: (DBD:
If you turn off AutoCommit, you can *should* be able to select max(id) from
the table. I don't know, offhand, if Access Supports, say select @@identity
(in fact, I believe it doesn't).
Be careful: don't commit before trying to select it...
Jeff
I'll be interested in hearing answers from
Just to confirm that I am using the safest method, this is what I have
working right now.
My table structure is this:
CREATE TABLE person
(
id integer NOT NULL, --changed to autonumber with Access GUI
fname varchar(20) NOT NULL,
mname varchar(20) NULL,
lname varchar(20) NOT NULL,
Thanks. I'll include it.
Tim.
On Fri, Mar 14, 2003 at 10:21:04AM +0100, [EMAIL PROTECTED] wrote:
Hi,
That Makefile.PL still leaves the -l:libcl.a which causes this error:
/usr/bin/ld: Invalid loader fixup in text space needed in output file for
symbol $005C in input file:
Looks like you're using DBI v1.32. Try DBI 1.35
Tim.
On Fri, Mar 14, 2003 at 02:22:38PM +0800, [EMAIL PROTECTED] wrote:
Dear sir,
I have a problem with installing the DBI. I get 2 test failed
when I perform make test and make test TEST_VERBOSE=1.
Attached is the
logging message.
Thank
Buy this book: Oracle performance tuning 101. You won't regret it.
Tim.
On Fri, Mar 14, 2003 at 10:54:24AM +0100, Filipe Vasconcelos wrote:
Hello,
Does anybody has any script that could give, detailed information about the
performance of an Oracle Database.
regards,
The message got to me - did the response get to you?
--
Jonathan Leffler ([EMAIL PROTECTED], [EMAIL PROTECTED])
#include disclaimer.h
Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/
Just to confirm that I am using the safest method, this is
what I have working right now.
My table structure is this:
CREATE TABLE person
(
id integer NOT NULL, --changed to autonumber with Access GUI
fname varchar(20) NOT NULL,
mname varchar(20) NULL,
lname varchar(20) NOT
Normal column aliasing I have no problems.
When I try to concatenate two columns and
then make an alias (ie. Session) then I
will get DBD::Oracle::db prepare failed:
ORA-00923: FROM keyword not found where
expected.
my $sql=q{ select sid||','||serial Session, username
from v$session
Session is a reserved word in oracle, not allowed for aliasing. You can try to use
sessions instead.
-Original Message-
From: Markham, Richard [mailto:[EMAIL PROTECTED]
Sent: Friday, March 14, 2003 11:05 AM
To: '[EMAIL PROTECTED]'
Subject: concatenating column aliasing
Normal column
Also, don't know if it just a typo but the serial column is actually called
serial#
Ken.
-Original Message-
From: Kong, Alan [mailto:[EMAIL PROTECTED]
Sent: 14 March 2003 16:12
To: Markham, Richard; [EMAIL PROTECTED]
Subject: RE: concatenating column aliasing
Session is a
[EMAIL PROTECTED] wrote:
There seems to be an issue with SQL::Statement 1.005. The following
SQL Statement works fine in 1.004:
SELECT operator_id,operator_description
FROM operator
For legacy reasons operator is treated as a SQL reserved word. The
next release will not work that way, until
Or you can double-quote the alias:
select sid||','||serial as SESSION,
--- Kong, Alan [EMAIL PROTECTED] wrote:
Session is a reserved word in oracle, not allowed for aliasing. You
can try to use sessions instead.
-Original Message-
From: Markham, Richard [mailto:[EMAIL PROTECTED]
On Fri, Mar 14, 2003 at 11:11:45AM -0500, Kong, Alan wrote:
Session is a reserved word in oracle, not allowed for aliasing. You can
try to use sessions instead.
Or put session in double-quotes:
SELECT sid || ',' || serial# as session from v$session
Ronald
After over 18 months of stability it gives me great pleasure to
say that the monstrous hunk of rock that is DBD::Oracle is rolling
forward once again...
file: $CPAN/authors/id/T/TI/TIMB/DBD-Oracle-1.13.tar.gz
size: 194630 bytes
md5: bcb1a887ac8f5da415a78fe7abb012b5
Special thanks are due
Please ignore previous test email to [EMAIL PROTECTED]
I'd forgotten that I'd set [EMAIL PROTECTED] to redirect to dbi-users.
Tim.
thanks for everyones help. My 'example' obviously
had a few problems's =). Kimball's suggestion using
as was ultimately what I needed.
~rewrite~
my $sql=q{ select sid||','||serial# as Sessinfo, username
from v$session };
TA.
--- Markham, Richard [EMAIL PROTECTED] wrote:
thanks for everyones help. My 'example' obviously
had a few problems's =). Kimball's suggestion using
as was ultimately what I needed.
~rewrite~
my $sql=q{ select sid||','||serial# as Sessinfo, username
from v$session };
You may
When installing (making) DBD:Oracle 1.12, I received the following error message:
make
(...snip...)
rm -f blib/arch/auto/DBD/Oracle/Oracle.so
LD_RUN_PATH=/usr/oracle/901/lib gcc -G Oracle.o dbdimp.o oci7.o oci8.o
/usr/oracle/901/rdbms/lib/defopt.o -o blib/arch/auto/DBD/Oracle/Oracle.so
yes you are correct. I had gotten confused between trying q, qq and what
not
and had built the example quickly without testing. I had thought that as
was
what saved the day. Thanks for the clarification =).
-Original Message-
From: M. Addlework [mailto:[EMAIL PROTECTED]
Sent: Friday,
Alex,
I can't seem to reproduce this on my side. Attached is my script that I use
to try to reproduce it.
Let me know if you have problems. Two things to check:
1) are you running the latest (MDAC 2.7) driver?
To answer some of your original questions:
1) MSSQL Server
OS: Solaris 2.7
Perl: 5.6.1
DBI - Installed and Tested.
When make(ing) DBD-Oracle-1.12 I receive the error message:
ld: fatal: file /usr/oracle/901/rdbms/lib/defopt.o: wrong machine class
ld: fatal: File processing errors. No output written to
blib/arch/auto/DBD/Oracle/Oracle.so
collect2: ld
Hi Jeff
I can't seem to reproduce this on my side. Attached is my script that I
use
to try to reproduce it.
have you tryed my .cgi script?
Let me know if you have problems. Two things to check:
1) are you running the latest (MDAC 2.7) driver?
i'm using MDAC 2.7.9001
To answer some of your
Changes in DBD::ODBC 1.05 March 14, 2003
Cleaned up Makefile.PL and added Informix support thanks to Jonathan
Leffler (see README.informix)
Added nicer error message when attempting to do anything while the database
is disconnected.
Fixed fetchrow_hashref('NAME_uc | NAME_lc') with
34 matches
Mail list logo
