Re: Building 32bit DBD-Oracle under 64bit Oracle install

[Lin Feng]

Sean,
 
I just tried it. It made no difference in my case: the Makefile generated
are exactly the same.

Env: Solaris 2.8; Oracle 10.1.0.2.0; Perl 5.8.3
 
BTW, 'perl Makefile.PL' reports that it cannot determine correct Oracle version.
I guess it does not know what to do with the two gidit in '10'.
 
Any one else seen this?
 
Thanks,
Lin

Sean Kelly [EMAIL PROTECTED] wrote:
Hi,

I think I've cracked it. The Makefile.PL in 1.15 is much better than the 
one from 1.14 at detecting whether you need the lib32 Oracle directory from 
a 64bit Oracle install but I think there is one flaw.

On line 74 $::opt_r is set to a default value of build. This value is 
causing $build_target to always be set to build at line 343 no matter 
what the logic on the two preceeding lines decide.

If I set $::opt_r = '' on line 74 then running perl Makefile.PL chooses 
the lib32 directory correctly and make runs cleanly.

Thanks,

-- 
Sean Kelly 


-
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online

sqlx functions

[Lin Feng]

Hi,
 
Have Oracle's SQLX function such as XMLAGG(), XMLELEMENT() been
impletemented in DBD::Oracle? I got an error (OCIDefinedObject call needed but not 
implemented yet]. This is on Oracle 9.2.
 
Thanks,
Lin


-
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!

Re: (Fwd) DBD::Oracle, Solaris 8, Oracle 9 and big bug on libclntsh

[Lin Feng]

To make DBI 1.30 and DBD 1.12 work for Oracle 9.2.0 on Solaris 2.8 and 2.6,  you have 
to make the following changes:

in $ORACLE_HOME/lib  [solaris 2.6/2.8, 32/64 bit Oracle]
  1. cp -p libclntsh.so.9.0 libclntsh.so.8.0
  2. cp -p libwtc9.so libwtc8.so

Good luck,
Lin
 Tim Bunce [EMAIL PROTECTED] wrote:- Forwarded message from Luc VEILLON 
(ERMES) -

Delivered-To: [EMAIL PROTECTED]
Date: Tue, 3 Dec 2002 16:14:59 +0100 (MET)
From: Luc VEILLON (ERMES) 
To: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: DBD::Oracle, Solaris 8, Oracle 9 and big bug on libclntsh
X-MailScanner: Found to be clean

Hello, 

If I'm not mistaking, each of you got a problem when installing DBD::Oracle
on Oracle 9 and Solaris. I've got the same, but I didn't find any answer on
the news after your mail. 

Did you succeed in installing DBD:: Oracle ? 

Thank's for any help ! 

Luc VEILLON | IRD/Dlgation aux systmes d'information/ 
tel.:+33(0)2 38 49 95 95 | Ple Securite 
Fax :+33(0)2 38 49 95 76 | 5, rue du carbone 
[EMAIL PROTECTED] | 45072 ORLEANS CEDEX 2


- End forwarded message -


-
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now

Connect as sysdba in 9i

[Lin Feng]

Hi,

Any idea on how to connect system/sys as sysdba in Oracle 9i through 
DBI? Any feedback is appreciated.

Thanks,
Lin





-
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now