@{ Home >> Teknik >> Perl << }

→[ Indhold | Links | Nyheder | Oracle | Programmering | Referencer | Teknik ]
CeDeT [se'de']
Perl
The Perl language was created with the goal of making "the easy things easy and the hard things possible".
Articles
  Introduction to using DBI and Oracle [PDF] (by Mladen Gogala) {DBI.pdf}
 
Links
  extproc_perl (Oracle Stored Procedures in Perl)
  perl.com   perl.org   CPAN   use Perl;   ActiveSTATE ActivePerl
Books
 
  • Andy Duncan , Jared Still: Perl for Oracle DBAs
    Book: Perl for Oracle DBAs - buy it at Amazon.co.uk

      Quote:
      If Gandalf the Wizard were to choose
      a scripting language, he would choose
      Perl.


  • Alligator Descartes, Tim Bunce: Programming the Perl DBI
    (Database Programming with Perl)
    Book: Programming the Perl DBI - buy it at Amazon.co.uk
 
DBD::Oracle
***   DBD::Oracle   *** - the homepage of the DBD::Oracle project
An Introduction to DBD::Oracle [PDF]

Installation of the DBD::Oracle perl module with Oracle instantclient under linux
 
  DBI, DBD::ODBC and DBD::Oracle for ActiveState Perl 5.8.x
(Last updated 20th September 2004)

Note that DBD::Oracle is now (it seems) available for Windows from ActiveState - see ASPN : ActivePerl : PPM.

See also:
   DBDOracle - Oracle database driver for the DBI module - search.cpan.org
   PPM packages from the University of Winnipeg
 
Before you download any of the files below be sure to check:
    Head page for Softmatic's DBI Binary repositories No more!?
 
  DBI, DBD::ODBC and DBD::Oracle for ActiveState Perl 5.8.4

For ActiveState Perl 5.8.4 (any build) here is a copy of the files from ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.4 (from 20th of September 2004):

DBD-DB2-0.76-5.8.4.tar.gz
DBD-DB2-0.77-5.8.4.tar.gz
DBD-DB2-0.78-5.8.4.tar.gz
DBD-DB2.ppd
DBD-ODBC-1.10-5.8.4.tar.gz
DBD-ODBC.ppd
DBD-Oracle-1.16-5.8.4.tar.gz
DBD-Oracle.ppd
DBD-Oracle9-1.16-5.8.4.tar.gz
DBD-Oracle9.ppd
DBI-1.43-5.8.4.tar.gz
DBI.ppd
 
  DBI, DBD::ODBC and DBD::Oracle for ActiveState Perl 5.8.3

With ActiveState Perl 5.8.3 (any build) use:
ppm install ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.3/DBI.ppd
ppm install ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.3/DBD-Oracle.ppd
ppm install ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.3/DBD-ODBC.ppd

If this fails try downloading the files locally (see Howto below). Here is a copy of the files from ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.3 (from 21st of February 2004):

DBD-DB2-0.76-5.8.3.tar.gz
DBD-DB2.ppd
DBD-ODBC-1.07-5.8.3.tar.gz
DBD-ODBC.ppd
DBD-Oracle-1.15-5.8.3.tar.gz
DBD-Oracle.ppd
DBI-1.40-5.8.3.tar.gz
DBI.ppd

 
  DBI, DBD::ODBC and DBD::Oracle for ActiveState Perl 5.8.2

With build 808 of ActiveState Perl 5.8.2 use:
ppm install ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.2/DBI.ppd
ppm install ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.2/DBD-Oracle.ppd
ppm install ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.2/DBD-ODBC.ppd

If this fails try downloading the files locally (see Howto below or read the INSTRUCTIONS from the author himself). Here is a copy of the files from ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.2 (from 3th of February 2004):

DBD-DB2-0.76-5.8.2.tar.gz
DBD-DB2.ppd
DBD-ODBC-1.06-5.8.2.tar.gz
DBD-ODBC.ppd
DBD-Oracle-1.15-5.8.2.tar.gz
DBD-Oracle.ppd
DBI-1.40-5.8.2.tar.gz
DBI.ppd

 
  DBI, DBD::ODBC and DBD::Oracle for ActiveState Perl 5.8.0

Here is a copy of ftp://ftp.esoftmatic.com/outgoing/DBI from 8th of July 2003 (see Announcement):

DBD-ODBC-1.03-5.8.tar.gz
DBD-ODBC-1.04-5.8.tar.gz
DBD-ODBC-1.06-5.8.tar.gz
DBD-ODBC.ppd
DBD-Oracle-1.12-5.8.tar.gz
DBD-Oracle-1.13-5.8.tar.gz
DBD-Oracle.ppd
DBI-1.32-5.8.tar.gz
DBI-1.37-5.8.tar.gz
DBI.ppd

Howto
  • Download all of the files listed above to a local directory (C:\jurlwin) on your PC
  • Start ActiveState Perl Package Manager (PPM)
  • Commands:
    rep add jurlwin C:\jurlwin
    install DBI
    install DBD-ODBC
    install DBD-Oracle

Even though the announcement says it is for build 805, I've managed to do a (seemingly) succesfull install on build 804. For additional Info DBI and DBD::Oracle check out DBI.perl.org.
 
Windows (ActivePerl 5.8.0) version of W3C's Link Checker Perl-script
  Modified version of checklink.pl (revision 3.6.2.17) available from CVS log for validator/httpd/cgi-bin/checklink.pl (from 14th of August 2003):

checklink_w32.zip

- contains:
  • checklink.pl - original downloaded (UNIX) version
  • checklink_w32.pl - modified (Windows) version
  • checklink_w32.bat - MS-DOS Bat(ch) program to call checklink_w32.pl
  • checklink_w32.conf - required configuration files (empty)
  • General.pm - Config::General perl module from CPAN

- how to use:
  • Download and unzip the zip-file into a local directory (C:\checklink) on your PC
  • Start a Command Prompt
  • Change directory to where you unzipped the files (i.e. C: followed by cd \checklink)
  • Start checklink_w32.bat (without any arguments) from the Command Prompt
    • If the program complains about some missing perl modules then install those using the ActiveState Perl Package Manager (PPM)
    • If you cannot seem to locate and install Config/General.pm using PPM then copy the downloaded file General.pm (originally downloaded from CPAN) to a directory named Config (that you may have to create yourself) located under the first path in @INC (usually C:\Perl\lib)
  • Start checklink_w32.bat with your favourite url or file as argument (i.e. checklink_w32.bat [http://www.CeDeT.dk/perl/]index.html)

The configuration file included above is empty, since I did not know what to put in it! W3C has a convenient web interface for all of this: W3C Link Checker. They also have some documentation on the Link Checker - I haven't read it, but you go ahead...
© 2003-2009 CeDeT - Sidst opdateret: 23. januar 2009.
Valid XHTML 1.0!