From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of ukhas jean Sent: 26 September 2006 05:34 To: Active Perl Subject: RE: perl-oracle connectivity query
> Hello Brian et al ... > > If u see my code i am using the DBI.pm module ... y do i need to have DBD::Oracle.pm installed then??? (Cause > this module is a huge one and my internet connection is not that good) ... DBI is just an interface layer. You need database driver modules (DBD) if you want it to talk to a database (see 'perldoc DBI'). > > I saw using TOAD that my environment variables werent set properly ... eg. ORACLE_HOME_NAME, ORACLE_HOME, > ORACLE_SID and NLS_LANG ... i set it properly ... and now my code works fine ... ORACLE_HOME is the important one for DBD::Oracle. ORACLE_SID helps too. > > But Brian, as per u, I should have DBD::Oracle installed ... but I didnot install it ... I only used DBI.pm and > it works fine ... I think the error shown by perl (as shown below) is a misleading one ... > > My Question: > 1. Is DBD::Oracle required to be install for DBI.pm to work properly?? If so, how did it work on my PC?? Cause > I dont have any DBD::Oracle installed on my machine!!! Yes, you must have DBD::Oracle for your script to work. If your script now works, then not only must DBD::Oracle be installed on your box, but perl knows how to find it. If you type 'perl -MDBD::Oracle -e 1' at the command prompt and it produces no error then this will confirm that perl can load the module. If that worked, type 'perl -MDBD::Oracle -MData::Dumper -de0' at the command prompt, which should start the debugger. At the debugger prompt type 'print Dumper(\%INC)', which will list all of the loaded modules and where they were loaded from, including DBD::Oracle. > > I feel like alice in wonderland ... plz advise!!! "Remember what the dormouse said. Feed your head." - White Rabbit - Jefferson Airplane. (Sorry if that is a bit too obscure.) HTH -- Brian Raven ================================= Atos Euronext Market Solutions Disclaimer ================================= The information contained in this e-mail is confidential and solely for the intended addressee(s). Unauthorised reproduction, disclosure, modification, and/or distribution of this email may be unlawful. If you have received this email in error, please notify the sender immediately and delete it from your system. The views expressed in this message do not necessarily reflect those of Atos Euronext Market Solutions. L'information contenue dans cet e-mail est confidentielle et uniquement destinee a la (aux) personnes a laquelle (auxquelle(s)) elle est adressee. Toute copie, publication ou diffusion de cet email est interdite. Si cet e-mail vous parvient par erreur, nous vous prions de bien vouloir prevenir l'expediteur immediatement et d'effacer le e-mail et annexes jointes de votre systeme. Le contenu de ce message electronique ne represente pas necessairement la position ou le point de vue d'Atos Euronext Market Solutions. _______________________________________________ ActivePerl mailing list [email protected] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
