Re: PPM available for DBD-Oracle 1.12 (OCI8)
Ilya Sterin wrote: PPM is now available for DBD-Oracle 1.12 compiled with Oracle 8 libs. This is how you can install... You must set your repository to http://www.xmlproj.com/PPM by doing... ppm set repository http://www.xmlproj.com Then you can install with ppm install DBD-Oracle-0_12 Big thanks to Maarten Koskamp for compiling this version. Ilya OK, looks like i'm having a caffeine free moment here, but it's not finding a PPD file. is the set command right? it's not the same as the one for the DBI PPM install. -- -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Every program is a part of some other program, and rarely fits.
Re: PPM available for DBD-Oracle 1.12 (OCI8)
ppm install DBD-Oracle-1_12 she made a typo it's 1_12 Etienne bill thater wrote: Ilya Sterin wrote: PPM is now available for DBD-Oracle 1.12 compiled with Oracle 8 libs. This is how you can install... You must set your repository to http://www.xmlproj.com/PPM by doing... ppm set repository http://www.xmlproj.com Then you can install with ppm install DBD-Oracle-0_12 Big thanks to Maarten Koskamp for compiling this version. Ilya OK, looks like i'm having a caffeine free moment here, but it's not finding a PPD file. is the set command right? it's not the same as the one for the DBI PPM install. -- -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Every program is a part of some other program, and rarely fits. -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001
Re: PPM available for DBD-Oracle 1.12 (OCI8)
Etienne Marcotte wrote: ppm install DBD-Oracle-1_12 she made a typo it's 1_12 still doesn't find it. Etienne bill thater wrote: Ilya Sterin wrote: PPM is now available for DBD-Oracle 1.12 compiled with Oracle 8 libs. This is how you can install... You must set your repository to http://www.xmlproj.com/PPM by doing... ppm set repository http://www.xmlproj.com Then you can install with ppm install DBD-Oracle-0_12 Big thanks to Maarten Koskamp for compiling this version. Ilya OK, looks like i'm having a caffeine free moment here, but it's not finding a PPD file. is the set command right? it's not the same as the one for the DBI PPM install. -- -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Every program is a part of some other program, and rarely fits. -- -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Every program is a part of some other program, and rarely fits.
RE: PPM available for DBD-Oracle 1.12 (OCI8)
Bill - Looks like you dropped a /ppm off the repository path in your original mail (look at Ilya's original post). Here's what just worked for me on a Win2k machine: D:\ppm PPM interactive shell (2.1.5) - type 'help' for available commands. PPM set repository XMLPROJ http://www.xmlproj.com/PPM PPM search DBD-Oracle* Packages available from http://www.xmlproj.com/PPM: DBD-Oracle-1_12 [1.12] DBD-Oracle 1.12 Packages available from http://ppm.ActiveState.com/cgibin/PPM/ppmserver.pl?urn:/ PPMServer: DBD-Oracle [1.06] Oracle database driver for the DBI module DBD-Oracle8 [1.06] Oracle 8 database driver for the DBI module PPM install DBD-Oracle-1_12 Install package 'DBD-Oracle-1_12?' (y/N): y Installing package 'DBD-Oracle-1_12'... Bytes transferred: 98144 Mark -- Mark Riehl Agile Communications, Inc. Email: [EMAIL PROTECTED] Business: (732) 528-9305 Fax: (732) 528-9308 Cell: (732) 996-7630 -Original Message- From: Thater, William [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 9:13 AM To: Etienne Marcotte Cc: [EMAIL PROTECTED]; Ilya Sterin Subject: Re: PPM available for DBD-Oracle 1.12 (OCI8) Etienne Marcotte wrote: ppm install DBD-Oracle-1_12 she made a typo it's 1_12 still doesn't find it. Etienne bill thater wrote: Ilya Sterin wrote: PPM is now available for DBD-Oracle 1.12 compiled with Oracle 8 libs. This is how you can install... You must set your repository to http://www.xmlproj.com/PPM by doing... ppm set repository http://www.xmlproj.com Then you can install with ppm install DBD-Oracle-0_12 Big thanks to Maarten Koskamp for compiling this version. Ilya OK, looks like i'm having a caffeine free moment here, but it's not finding a PPD file. is the set command right? it's not the same as the one for the DBI PPM install. -- -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Every program is a part of some other program, and rarely fits. -- -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] -- -- You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. -- -- Every program is a part of some other program, and rarely fits.
Re: PPM available for DBD-Oracle 1.12 (OCI8)
Mark Riehl wrote: Bill - Looks like you dropped a /ppm off the repository path in your original mail (look at Ilya's original post). Here's what just worked for me on a Win2k machine: DUH! like i said, a caffeine free moment.;-) worked fine now. thanks. -- -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Every program is a part of some other program, and rarely fits.
RE: PPM available for DBD-Oracle 1.12 (OCI8)
William you must issue these commands. ppm set repository XMLPROJ http://www.xmlproj.com/PPM ppm install DBD-Oracle-0_12 If you are behind the firewall you must configure for ppm to bypass it, look at the docs. You must set three envs HTTP_proxy HTTP_proxy_user HTTP_proxy_pass Ilya -Original Message- From: Thater, William To: Etienne Marcotte Cc: [EMAIL PROTECTED]; Sterin, Ilya Sent: 11/20/01 7:12 AM Subject: Re: PPM available for DBD-Oracle 1.12 (OCI8) Etienne Marcotte wrote: ppm install DBD-Oracle-1_12 she made a typo it's 1_12 still doesn't find it. Etienne bill thater wrote: Ilya Sterin wrote: PPM is now available for DBD-Oracle 1.12 compiled with Oracle 8 libs. This is how you can install... You must set your repository to http://www.xmlproj.com/PPM by doing... ppm set repository http://www.xmlproj.com Then you can install with ppm install DBD-Oracle-0_12 Big thanks to Maarten Koskamp for compiling this version. Ilya OK, looks like i'm having a caffeine free moment here, but it's not finding a PPD file. is the set command right? it's not the same as the one for the DBI PPM install. -- -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] -- -- You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. -- -- Every program is a part of some other program, and rarely fits. -- -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Every program is a part of some other program, and rarely fits.
Inserting data file into table
Hi
I slurped a data file into an array and I know there are many ways of
inserting the fields into a table. I was just wondering what the most
efficient way would be.
Here are the relevent code snippets.
--
my $id, $fname, $lname, $phone, $deptid, @table;
my $file = c:\\test\\people.csv;
open(FILE, $file) or die can't open file: $!;
while (FILE) {
@table = split(/,/ , $file );
--
my $sth = $dbh-prepare( INSERT INTO tbl_people VALUES (?,?,?,?,?) );
foreach (@table){
($id, $fname, $lname, $phone, $deptid) = split;
$sth-execute($id, $fname, $lname, $phone, $deptid);
}
--
or should I us a do() or something else.
Thanks for any help
Jim
Re: PPM available for DBD-Oracle 1.12 (OCI8)
In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... PPM is now available for DBD-Oracle 1.12 compiled with Oracle 8 libs. This is how you can install... You must set your repository to http://www.xmlproj.com/PPM by doing... ppm set repository http://www.xmlproj.com Then you can install with ppm install DBD-Oracle-0_12 Big thanks to Maarten Koskamp for compiling this version. Ilya I'm having trouble connecting to this site. At first I got a read error: C:\Perlppm PPM interactive shell (1.1.1) - type 'help' for available commands. PPM set repository XMLPROJ http://www.xmlproj.com/PPM PPM search DBD-Oracle* Packages available from http://www.xmlproj.com/PPM: DBD-Oracle-1_12 [1.12] DBD-Oracle 1.12 Packages available from http://www.activestate.com/Packages/: DBD-Oracle [1.03] Oracle database driver for the DBI module PPM install DBD-Oracle-1_12 Install package 'DBD-Oracle-1_12?' (y/N): y Retrieving package 'DBD-Oracle-1_12'... Error installing package 'DBD-Oracle-1_12': Read of http://www.xmlproj.com/PPM/ failed PPM I associated this with a firewall problem, so we used a dial-up instead, but got the same error- can't even search. Now I'm unable to connect at all. Did something happen to this location? Thanks- Becka
how to execute a sql command file within a perl script
Hi All, Using a perl script (with the DBI module) I am trying to connect to a oracle database using sqlplus (which is there in the oracle BIN directory) and then executing a command file by using the command start commands.sql. Can somebody help me in implementing this ?? I am not very sure about how to write the perl code for doing this. (Also please note that the command file expects some input from the user. So please let me know how to implement this code as well!!) All help will be highly appreciated. Thanks.
newbie trying to connect to an access database...
Hi there, I am trying to connect to an access database through DBI (and DBD::ODBC); I have openlink drivers installed and get errors that the connection has failed: Data Source name not found and no default driver specified. I am also trying to go by specifying the DSN as driver=Microsoft Access Driver (*.mdb);dbq=location of the db I am sure this problem has been talked about at length in the past; if one could point to an archive or thread, it would be most appreciated. Thanks so much, chirag
RE: how to execute a sql command file within a perl script
you can just wrap the commands from the sql plus file into a prepare string. something like: my $sth = $dbh-prepare( SELECT * FROM tbl_foo WHERE description = $blah # whatever statements you have in the sq file ); $sth-execute(); perldoc dbi details -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 1:54 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: how to execute a sql command file within a perl script Hi All, Using a perl script (with the DBI module) I am trying to connect to a oracle database using sqlplus (which is there in the oracle BIN directory) and then executing a command file by using the command start commands.sql. Can somebody help me in implementing this ?? I am not very sure about how to write the perl code for doing this. (Also please note that the command file expects some input from the user. So please let me know how to implement this code as well!!) All help will be highly appreciated. Thanks.
Info about DBI::Sybase.
Hy all I´m a beginer. I´m looking for any information about DBI::Sybase. Where i can get it ?? Thanks. Gregory
Re: Info about DBI::Sybase.
Install DBD::Sybase and then perldoc DBD::Sybase Also, the Programming the Perl DBI is a good reference book to have. HTH, Curt On Tue, 20 Nov 2001, Mcgregory Pinto wrote: Hy all I´m a beginer. I´m looking for any information about DBI::Sybase. Where i can get it ?? Thanks. Gregory
Re: how to execute a sql command file within a perl script
Make sure that 1) Oracle is installed and working 2) DBI installed ok 3) DBD::Oracle installed ok then, you'll need a proper connect statement - look at the DBD::Oracle perldocs by doing perldoc DBD::Oracle And then try the code below. HTH. -- Hardy Merrill Mission Critical Linux, Inc. http://www.missioncriticallinux.com Kipp, James [[EMAIL PROTECTED]] wrote: you can just wrap the commands from the sql plus file into a prepare string. something like: my $sth = $dbh-prepare( SELECT * FROM tbl_foo WHERE description = $blah # whatever statements you have in the sq file ); $sth-execute(); perldoc dbi details -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 1:54 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: how to execute a sql command file within a perl script Hi All, Using a perl script (with the DBI module) I am trying to connect to a oracle database using sqlplus (which is there in the oracle BIN directory) and then executing a command file by using the command start commands.sql. Can somebody help me in implementing this ?? I am not very sure about how to write the perl code for doing this. (Also please note that the command file expects some input from the user. So please let me know how to implement this code as well!!) All help will be highly appreciated. Thanks.
Re: newbie trying to connect to an access database...
dbi-users archives can be found at http:[EMAIL PROTECTED]/ and the other thing you should be able to do if DBD::ODBC is installed is bring up a DOS window and at the command prompt type perldoc DBD::ODBC and it should lay out the different connect options. I would think they may have info in there about connecting to an Access DB, but I don't know for sure. HTH. -- Hardy Merrill Mission Critical Linux, Inc. http://www.missioncriticallinux.com Chirag Patel [[EMAIL PROTECTED]] wrote: Hi there, I am trying to connect to an access database through DBI (and DBD::ODBC); I have openlink drivers installed and get errors that the connection has failed: Data Source name not found and no default driver specified. I am also trying to go by specifying the DSN as driver=Microsoft Access Driver (*.mdb);dbq=location of the db I am sure this problem has been talked about at length in the past; if one could point to an archive or thread, it would be most appreciated. Thanks so much, chirag
Checking result of MS Access insert statement
I'm using DBI:ODBC to talk with a Microsoft Acces database and things are going along swimmingly, but I have this one issue... I can perform an INSERT statement successfully. Immediately after I do the INSERT, this line... my $rowcount = $sth-rows; returns a value of 1, indicating a successful operation. But I was also hoping that this line... my @resultsarray = $sth-fetchrow_array; would return the row that I just inserted, or at least the primary key of the new row (an autoincremented number). But it doesn't of course, the @resultsarray is empty. So my question is after I do an insert how can I immediately get ahold of the entry I just made? Immediately doing a SELECT right after the INSERT seems terribly inelegant. Chris Spurgeon Senior Design Technologist [EMAIL PROTECTED] ELECTRONIC INK One South Broad Street 19th Floor Philadelphia, PA 19107 www.electronicink.com t 215.922.3800 x(233) f 215.922.3880 This e-mail is intended solely for the above-mentioned recipient and it may contain confidential or privileged information. If you have received it in error, please notify us immediately and delete the e-mail. You must not copy, distribute, disclose or take any action in reliance on it. In addition, the contents of an attachment to this e-mail may contain software viruses which could damage your own computer system. While Electronic Ink, Inc. and E Ink Ltd have taken every reasonable precaution to minimize this risk, we cannot accept liability for any damage which you sustain as a result of software viruses. You should perform your own virus checks before opening the attachment.
Re: Checking result of MS Access insert statement
Chris Spurgeon wrote: I'm using DBI:ODBC to talk with a Microsoft Acces database and things are going along swimmingly, but I have this one issue... I can perform an INSERT statement successfully. Immediately after I do the INSERT, this line... my $rowcount = $sth-rows; returns a value of 1, indicating a successful operation. But I was also hoping that this line... my @resultsarray = $sth-fetchrow_array; would return the row that I just inserted, or at least the primary key of the new row (an autoincremented number). But it doesn't of course, the @resultsarray is empty. So my question is after I do an insert how can I immediately get ahold of the entry I just made? Immediately doing a SELECT right after the INSERT seems terribly inelegant. Try doing a select @@identity right after the insert (on the same connection). Michael
retrieving exit value from SQL function in Perl
Does anyone know how to get an exit value from the following? If I have: $insert_cr= $dbh-prepare(DECLARE result_cr VARCHAR2(30); BEGIN result_cr := SYSTEM.LoadCreditReport(?,?,?); END;); #crr_id, directory, filename are the three ?s Where LoadCreditReport returns a string stating whether or not it succeeded, and if it failed, why it failed- how can I get the value of result_cr? Or can I? Thanks, I am trying to take a different tack on the same problem I couldn't resolve, before. Becka Louden
RE: Checking result of MS Access insert statement
That's it! That returns my primary key, thanks Michael! PS One caveat, ya have to make sure you escape those @ signs. Like this... $sth = $dbh-prepare( select \@\@identity); $sth-execute(); Chris Spurgeon Senior Design Technologist [EMAIL PROTECTED] ELECTRONIC INK One South Broad Street 19th Floor Philadelphia, PA 19107 www.electronicink.com t 215.922.3800 x(233) f 215.922.3880 -Original Message- From: Michael Peppler [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 5:21 PM To: Chris Spurgeon Cc: '[EMAIL PROTECTED]' Subject: Re: Checking result of MS Access insert statement Chris Spurgeon wrote: I'm using DBI:ODBC to talk with a Microsoft Acces database and things are going along swimmingly, but I have this one issue... I can perform an INSERT statement successfully. Immediately after I do the INSERT, this line... my $rowcount = $sth-rows; returns a value of 1, indicating a successful operation. But I was also hoping that this line... my @resultsarray = $sth-fetchrow_array; would return the row that I just inserted, or at least the primary key of the new row (an autoincremented number). But it doesn't of course, the @resultsarray is empty. So my question is after I do an insert how can I immediately get ahold of the entry I just made? Immediately doing a SELECT right after the INSERT seems terribly inelegant. Try doing a select @@identity right after the insert (on the same connection). Michael This e-mail is intended solely for the above-mentioned recipient and it may contain confidential or privileged information. If you have received it in error, please notify us immediately and delete the e-mail. You must not copy, distribute, disclose or take any action in reliance on it. In addition, the contents of an attachment to this e-mail may contain software viruses which could damage your own computer system. While Electronic Ink, Inc. and E Ink Ltd have taken every reasonable precaution to minimize this risk, we cannot accept liability for any damage which you sustain as a result of software viruses. You should perform your own virus checks before opening the attachment.
How to retrieve NLS_DATE_FORMAT
Hello dbi users,
I'm using dbi to connect to an Oracle 8i database.
I'm trying to retrieve the size of a date datatype column for a table.
First I tried with $query-{TYPE}, and $query-{PRECISION} functions
but I got weird result (75 for the precision ???).
So, I am now trying to get the current NLS_DATE_FORMAT value.
I know how to set it ('ALTER SESSION SET NLS_DATE_FORMAT = '$nls_date_format')
but is there any way to retrieve it directly ?
Thanks in advance for your help.
Frederic Fachinetti
[EMAIL PROTECTED]
**
O.S.B
Oceanienne de Services Bancaires
BP 9178 Motu Uta
98715 Papeete
Tahiti - Polynesie Francaise
Site : http://www.osb.pf
Tel : (689) 54 08 00
Fax : (689) 41 34 08
**
Ce message et toutes les pieces jointes (ci-apres le message) sont
etablis a l'intention exclusive de ses destinataires et sont confidentiels.
Si vous recevez ce message par erreur, merci de le detruire et d'en
avertir immediatement l'expediteur.
Toute utilisation de ce message non conforme a sa destination,
toute diffusion ou toute publication, totale ou partielle, est interdite,
sauf autorisation expresse.
L'Internet ne permettant pas d'assurer l'integrite de ce message,
l'OSB decline toute responsabilite au titre de ce message, dans
l'hypothese ou il aurait ete modifie ou infeste par un virus.
Re: Checking result of MS Access insert statement
On Tue, 20 Nov 2001 17:39:58 -0500, in perl.dbi.users you wrote: PS One caveat, ya have to make sure you escape those @ signs. Like this... $sth = $dbh-prepare( select \@\@identity); Or like this: $sth = $dbh-prepare( 'select @@identity' ); Cheers, Philip
Re: Inserting data file into table
Kipp, James wrote:
Hi
I slurped a data file into an array and I know there are many ways of
inserting the fields into a table. I was just wondering what the most
efficient way would be.
Here are the relevent code snippets.
--
my $id, $fname, $lname, $phone, $deptid, @table;
my $file = c:\\test\\people.csv;
open(FILE, $file) or die can't open file: $!;
while (FILE) {
@table = split(/,/ , $file );
--
my $sth = $dbh-prepare( INSERT INTO tbl_people VALUES (?,?,?,?,?) );
foreach (@table){
($id, $fname, $lname, $phone, $deptid) = split;
$sth-execute($id, $fname, $lname, $phone, $deptid);
}
--
or should I us a do() or something else.
That's about as good as it gets if you use DBD::Informix.
YMMV if you use a different database driver, but probably not by much.
--
Jonathan Leffler ([EMAIL PROTECTED], [EMAIL PROTECTED])
Guardian of DBD::Informix 1.00.PC1 -- see http://www.cpan.org/
#include disclaimer.h
