DBD::Oracle on HPUX 10.20 with PA 2.0

2001-04-19 Thread S Bala
Hi All, Did any successfully tried using DBD::Oracle on HPUX 10.20 with Processor Architecture 2.0 ? I would appreciate your help in this regard. Regards, S Bala --- FREE! The World's Best Email Address @email.com Reserve your name now at htt

Re: ISA inheritance vs. DBI?

2001-04-19 Thread Stephen Clouse
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, Apr 19, 2001 at 05:42:43PM -0400, Paul D. Smith wrote: > I'm trying to create a subclass of the DBI class. [snip] Look at t/subclass.t in the DBI distribution for an example. Subclassing DBI isn't as simple as setting @ISA -- but it isn't te

Oracle DBD 1.06 compile problems

2001-04-19 Thread Kevin Leahy
Hi There I'm having a problem compiling the Oracle 1.06 DBD at my site. Below is the output requested from the README file. I'm running HPUX 11.0 and Oracle 8.0.5.1 both in 64bit mode. I'm a perl newbie so I'm hoping this is something simple. I contacted Oracle but their response was less than e

Re: ISA inheritance vs. DBI?

2001-04-19 Thread James Maes
connect { my($that) = shift; my $class = ref($that) || $that; my $self = bless $that->SUPER::new(@_), $class; $self->{class} = $class; return(self); } ?? On Thursday 19 April 2001 16:42, Paul D. Smith wrote: > I'm trying to create a subclass of the DBI class. My goal is twofold

ISA inheritance vs. DBI?

2001-04-19 Thread Paul D. Smith
I'm trying to create a subclass of the DBI class. My goal is twofold: 1) Override the connect method so that I can hide many of the details of connecting from the rest of my package, and 2) Add a few extra "helper" methods. I want to access my extra helper methods, plus all the standard

Problem installing DBI module into Perl 5.6

2001-04-19 Thread Ben McGough
Below is all the information I have as well as the error messages I'm seeing: Executing make realclean... rm -f blib/script/dbiproxy blib/script/dbish rm -rf Perl.c DBI.c DBI-1.15 Perl.xsi dbish dbiproxy ndtest.prt ./blib Makefile.aperl blib/arch/auto/DBI/extralibs.all perlmain.c mon.out core c

Re: DBIx::XML_RDB

2001-04-19 Thread M.W. Koskamp
> > -Original Message- > > From: Thirumalai, Radhika > > Sent: Thursday, April 19, 2001 4:25 PM > > To: '[EMAIL PROTECTED]' > > Subject: DBIx::XML_RDB > > > > I'm trying to export data from a database to an XML file using > > DBIx::XML_RDB module. > > When I execute the code below, i get

Re: FW: DBIx::XML_RDB

2001-04-19 Thread Matt Sergeant
On Thu, 19 Apr 2001, Thirumalai, Radhika wrote: > > > > -Original Message- > > From: Thirumalai, Radhika > > Sent: Thursday, April 19, 2001 4:25 PM > > To: '[EMAIL PROTECTED]' > > Subject:DBIx::XML_RDB > > > > I'm trying to export data from a database to an XML file

FW: DBIx::XML_RDB

2001-04-19 Thread Thirumalai, Radhika
> -Original Message- > From: Thirumalai, Radhika > Sent: Thursday, April 19, 2001 4:25 PM > To: '[EMAIL PROTECTED]' > Subject: DBIx::XML_RDB > > I'm trying to export data from a database to an XML file using > DBIx::XML_RDB module. > When I execute the code below, i g

Re: RE: error connecting through webserver (IIS)

2001-04-19 Thread Michael A. Chase
That's libwin32 version 0.16. It's available in CPAN, but if you are using ActiveState Perl, you should install it using PPM. -- Mac :}) ** I normally forward private database questions to the DBI mail lists. ** Give a hobbit a fish and he'll eat fish for a day. Give a hobbit a ring and he'll eat

Re: Count on rows returned

2001-04-19 Thread Michael A. Chase
Count them as you fetch them. -- Mac :}) ** I normally forward private database questions to the DBI mail lists. ** Give a hobbit a fish and he'll eat fish for a day. Give a hobbit a ring and he'll eat fish for an age. - Original Message - From: "Reuss, Bob" <[EMAIL PROTECTED]> To: <[EMAIL

RE: RE: error connecting through webserver (IIS)

2001-04-19 Thread Prasanna Gopalakrishna
Linda, I'm trouble finding the module Libwin320.16 where did you get this? Appreciate your help! -Prasanna > From: Linda Xu <[EMAIL PROTECTED]> > Date: 2001/04/19 Thu AM 10:53:00 EDT > To: "'Prasanna Gopalakrishna'" <[EMAIL PROTECTED]> > Subject: RE: RE: error connecting through webserver (II

Count on rows returned

2001-04-19 Thread Reuss, Bob
Hello all, I was wondering, what would be the best way to get a count of the number of rows returned from a select statement using DBI::ODBC? Thanks, Bob Reuss

Re: RE: Error in connecting to Oracle through IIS

2001-04-19 Thread Prasanna Gopalakrishna
I need to connect to Oracle Unicode database. I believe that connects only through 8.1.5 or 8.1.6 Any suggestions appreciated > > From: [EMAIL PROTECTED] > Date: 2001/04/19 Thu PM 12:37:00 EDT > To: [EMAIL PROTECTED], >[EMAIL PROTECTED], [EMAIL PROTECTED] > Subject: RE: Error in connecti

Re: RE: error connecting through webserver (IIS)

2001-04-19 Thread Prasanna Gopalakrishna
what did you do for your success on WIN-NT? > From: Linda Xu <[EMAIL PROTECTED]> > Date: 2001/04/19 Thu AM 09:12:21 EDT > To: "'Prasanna Gopalakrishna'" <[EMAIL PROTECTED]> > Subject: RE: error connecting through webserver (IIS) > > Hi, I have same problem on one WIN2000. But I was successful o

Re: Fetch failure

2001-04-19 Thread Hugh Riley
At 11:17 AM 4/19/2001 -0400, Jim Lambert wrote: >Are you using Oracle in Shared Server mode (MTS)? > >We had this problem with Oracle 8.1.5 and 8.1.6 in MTS mode. When we >switched to Dedicated Server mode, it went away. BTW, this is a >'know' Oracle bug and it's suppose to be fixed in 8.1.7, bu

test mail

2001-04-19 Thread Anurag Minocha
Test Mail

Re: DBD::Sybase: the easiest way to fetch a number returned by stored proc?

2001-04-19 Thread Michael Peppler
Alexander Farber (EED) writes: > Hi, > > I have the following simple stored prcedure, > which returns 1 on any error or 0 on success: You can use the syb_do_proc_status, if you only need to know success/failure status: syb_do_proc_status (bool) Setting this attribute caus

Re: Fetch failure

2001-04-19 Thread Jim Lambert
Are you using Oracle in Shared Server mode (MTS)? We had this problem with Oracle 8.1.5 and 8.1.6 in MTS mode. When we switched to Dedicated Server mode, it went away. BTW, this is a 'know' Oracle bug and it's suppose to be fixed in 8.1.7, but we haven't tested it yet. -Jim Tim Bunce mutte

Re: Can't build DBD with Oracle 8.1.6 and OAS 4

2001-04-19 Thread Agamemnon Kaimakis
Thanks Tim. The problem is that it is exactly the LD_LIBRARY_PATH that I need to set. I'll try to set it through the web server if that's possible. Is it foreseen whether the next release of DBD::Oracle will fully support Oracle 8.1.6 (including its java components)? Regards, Agamemnon Tim Bun

Re: Fetch failure

2001-04-19 Thread Hugh Riley
At 03:03 PM 4/19/2001 +0100, Tim Bunce wrote: >Some people have reported problems with DBI 1.15 + DBD::Oracle 1.06. >Please try using DBI 1.14 and see if that helps. >Please _do_ let me know if that helps. Actually, I was running 1.14 up until a few hours before I sent the message. I upgraded wi

Re: Fetch failure

2001-04-19 Thread Tim Bunce
Some people have reported problems with DBI 1.15 + DBD::Oracle 1.06. Please try using DBI 1.14 and see if that helps. Please _do_ let me know if that helps. Tim. On Thu, Apr 19, 2001 at 02:09:52AM -0500, Hugh Riley wrote: > First of all, I am new to perl, so be gentle with me. Any assistance wou

Re: DBI-1.15 and DBD-Oracle-1.06 (2nd)

2001-04-19 Thread Tim Bunce
On Thu, Apr 19, 2001 at 08:57:26AM -0400, Duncan, Mike wrote: > > PS: I have contacted Tim Bunce about this issue, in hopes he can enlighten > me furthur. I'll certainly be looking at it but as I'm away next week it may not get sorted till the following week. Tim.

(Fwd) Installation Issues - DBI in Win 95

2001-04-19 Thread Tim Bunce
- Forwarded message from [EMAIL PROTECTED] - From: [EMAIL PROTECTED] () X-eGroups-Return: [EMAIL PROTECTED] Date: Thu, 19 Apr 2001 09:47:31 - To: [EMAIL PROTECTED] Subject: Installation Issues - DBI in Win 95 User-Agent: eGroups-EW/0.82 X-Originating-IP: 164.164.87.21 Dear Tim Bunce,

Re: Can't build DBD with Oracle 8.1.6 and OAS 4

2001-04-19 Thread Tim Bunce
On Thu, Apr 19, 2001 at 04:57:31PM +0300, Agamemnon Kaimakis wrote: > Mark, > > I have tried that and it doesn't work in this case. It seems that the env vars > must be set before the loading of the perl interpreter (e.g. through a wrapper > script?). Only applies to LD_LIBRARY_PATH. Many http

error connecting through webserver (IIS)

2001-04-19 Thread Prasanna Gopalakrishna
WIN-NT 4.0 Oracle 8.1.5 client IIS 4 Activestate perl 5.6.0 build 623 I can execute all other perl programs through IIS web server except connect to oracle data base. Surprisingly, I able to connect to database at command prompt. Anything to do at Web server configuration...? Error goes lik

Problem recompiling DBD::Oracle

2001-04-19 Thread Dave Tamillow
Good morning all, I need a sanity check here. I'm using PERL 5.005_03, DBI-1.14 and DBD-Oracle.1.06 on a Solaris 8 box. I also have SQL*PLUS installed. I had everything compiled and working fine from the command line. I wrote a web interface to run a CGI script making DBD::Oracle calls, and

Re: Can't build DBD with Oracle 8.1.6 and OAS 4

2001-04-19 Thread Mark Vandenbroeck
Agamemnon, What I usually do (because I have no control over the environment passed to me by the webserver) is set all my Oracle-related env vars in the CGI script itself. Like $ENV{ORACLE_SID} = 'MYSID'; $ENV{ORACLE_HOME} = '/u01/app/oracle/product/8.1.7'; $ENV{LD_LIBRARY_PATH} =

Re: Can't build DBD with Oracle 8.1.6 and OAS 4

2001-04-19 Thread Agamemnon Kaimakis
Mark, I have tried that and it doesn't work in this case. It seems that the env vars must be set before the loading of the perl interpreter (e.g. through a wrapper script?). Regards, Agamemnon Mark Vandenbroeck wrote: > > Agamemnon, > > What I usually do (because I have no control over the

RE: DBI-1.15 and DBD-Oracle-1.06 (2nd)

2001-04-19 Thread Duncan, Mike
I (and others) have seen various problems in using DBI-1.15 and DBD-Oracle-1.06. The only way I could find to solve the segfaults was to downgrade to DBI-1.14. All you would have to do is compile and install. I was having trouble with retrieving record sets from Oracle (getting segfaults instead

CSV ? Question...

2001-04-19 Thread Nicolas JOURDEN
Hi, I'd like to do something using DBD::CSV, it's like a good system but does he understand DELETE, UPDATE, DROP reuquest (in sql statement...) ? There's no information about this kind of things Well thnks... Ps : an other question, in the same way but, i'd like to do a a report system

Re: Can't build DBD with Oracle 8.1.6 and OAS 4

2001-04-19 Thread Agamemnon Kaimakis
Mark, thanks for the suggestion. It is useful for managing the environment and helped me to build DBD without the OAS libs. But my GGI scripts which use DBI and are served by the OAS listener do not work. They hang just before the $dbh = DBI->connect. The OAS listener's LD_LIBRARY_PATH points to

DBD::Sybase: the easiest way to fetch a number returned by stored proc?

2001-04-19 Thread Alexander Farber (EED)
Hi, I have the following simple stored prcedure, which returns 1 on any error or 0 on success: create procedure insert_update_sub @sub varchar (20), @path varchar (255) as begin tran if exists (select * from SUBSYSTEMS where SUB = @sub)

Re: Help needed on DBD::Oracle,please

2001-04-19 Thread S Bala
Hi Mark, Thanx very much for the info. But i could still see the hanging script after changing the connection string to 'dbi:Oracle:IRDO'. I would appreciate if u could suggest me in this regard. Regards, S Bala --Original Message-- From: Mark Vandenbroeck <[EMAIL PROTECTED]> To

DBD::Pg 0.96 user argument bug

2001-04-19 Thread Dylan Alex Simon
Sorry if this is the wrong address for DBD bugs -- the one in the docs ([EMAIL PROTECTED]) doesn't seem to work. Pg.pm connect doesn't seem to use the second (user) argument correctly. It seems the sense of the test is reversed to get the user and auth arguments, since it should only use the

Re: Can't build DBD with Oracle 8.1.6 and OAS 4

2001-04-19 Thread Mark Vandenbroeck
Agamemnon, This hasn't anything to do with DBI or DBD anymore, but here it is : Yes, you shouldn't mix both sets of libraries in your LD_LIBRARY_PATH. What I usually do is modify oraenv (there's a place provided for custom code near the end of the script) to set LD_LIBRARY_PATH so that it only

Re: Can't build DBD with Oracle 8.1.6 and OAS 4

2001-04-19 Thread Agamemnon Kaimakis
Mark, thanks for the reply. Indeed, I use different ORACLE_HOMEs for the various products. Also, before installing the DBD I use oraenv to set ORACLE_HOME to the RDBMS. I've noticed that my problem is with the LD_LIBRARY_PATH as follows: 1- If I remove the OAS lib paths -> DBD works, OAS won't s

Re: (Fwd) using perl with oracle 8.1.6

2001-04-19 Thread Mark Vandenbroeck
Yoel, This is because DBD::Oracle was linked against the 8.1.5 libclntsh.so from Oracle, and now your providing it the 8.1.6 version. Solution is to 'make' DBD::Oracle again. Mark Tim Bunce wrote: > - Forwarded message from Yoel Steinmets - B&H Photo Video ><[EMAIL PROTECTED]> - > >

Re: Can't build DBD with Oracle 8.1.6 and OAS 4

2001-04-19 Thread Mark Vandenbroeck
Agamemnon, The solution to your problem (and the recommended way of installing, regardless of DBD stuff) is to install your RDBMS and OAS in a separate ORACLE_HOME. When you install DBD, your ORACLE_HOME should be pointing to the RDBMS. If you don't install in separate ORACLE_HOMEs, you will r

Can't build DBD with Oracle 8.1.6 and OAS 4

2001-04-19 Thread Agamemnon Kaimakis
Hi dbi-users, I have problems building DBD 1.06 with Oracle 8.1.6 and Oracle Application Server 4.0.8.2 I upgraded Oracle from 8.0.4 -> 8.1.6 and OAS from 3.0.2 -> 4.0.8.2 (configuration: Solaris 2.6, Perl 5.005_03, DBI 1.15 and DBD 1.06). Make test returns the message "You must install a Solaris