Submitted by dmann on Thu, 06/07/2012 - 12:16
While helping a developer at my company get up and running with some DBI/DBD stuff I came across the Open Source Strawberry Perl distribution for Windows. It is an all-in-one package of Perl interpreter and many common packages required to get productive. Hopefully gone are the days of struggling to find a DBD driver compiled for Windows... From the website: Read more about Strawberry Perl + DBD::Oracle for MS Windows...
Submitted by dmann on Tue, 03/27/2012 - 11:36
Modern Perl by Chromatic is a freely available Perl eBook. It is a good resource for folks already familiar with programming that want to get up to speed quickly on Perl conventions and syntax.
Previously I used to use a collection of OReilly books to cover this territory but have replaced with 1 copy of Modern Perl (well with the exception of the Cookbooks, you will pry them out of my cold dead hands). Read more about Freely Available Perl Resource - Modern Perl by Chromatic
Submitted by dmann on Fri, 10/14/2011 - 17:18
Submitted by dmann on Fri, 10/14/2011 - 17:00
Purpose:
This Perl script will extract the SQL Statements out of an Oracle 10046 Trace File.
Usage:
trc2sql.pl output.sql
Source Code
trc2sql.pl :
#!/usr/bin/perl
# David Mann
# ba6.us
# Extract SQL from an Oracle SQL Trace File (10046)
#
# Usage:
# Data is read from STDIN
# trc2sql.pl output.sql
#
# Change log:
# 13-OCT-2011 : Release
$InSQL = 0;
while () {
$MyLine = $_;
$LineNum = $LineNum + 1;
# If END OF STMT found, stop printing
Read more about trc2sql.pl - Extract SQL Statements From Oracle 10046 Trace File
Submitted by dmann on Sun, 03/28/2010 - 00:50
Purpose
Monitor Long Operations inside an Oracle Database using Perl/DBI.
This can be useful for monitoring Table Scans, Index Rebuilds, and Exports.
Source Code
http://ba6.us/CodeExamples/Perl-LongOps
Submitted by dmann on Thu, 04/30/2009 - 12:20
Here is the problem, I've got a Perl script that I created to run via CGI using Oracle's Apache and Perl setup. I no longer want to run it as CGI, I just want to run it from the command line. The Perl apache environment and the default Solaris Perl environment are different and I cannot get my script to run from the command line without errors. The Solaris Perl environment doesn't have the same modules available as the Oracle install and I need some for my script to run.
Submitted by dmann on Fri, 04/25/2008 - 23:36
Looks like Oracle has finally come around and made it easier to incorporate the DBI module into the Oracle HTTP Server. The 10gR2 HTTP Server Administrators guide also has a laundry list of other modules that are enabled by default or easily turned on.
Here is the mod_perl section of the 10gR2 HTTP Server Admininistrators Guide:
click here
Submitted by dmann on Mon, 01/14/2008 - 12:53
I just downloaded and installed the latest version of ActiveState Perl for Win32. After installation I started to hit the laundry list of post-install tasks and noticed that 1) there is a new graphical Perl Package Manager and 2) I couldn't install DBI and DBD-Oracle because they were already installed! No more looking for the old ESoftmatic drivers!
Submitted by dmann on Wed, 10/03/2007 - 23:49
I've been using TextPad for writing Perl programs forever. TextPad is a pretty lightweight editor with a lot of decent features. Its nice because you can set up a PL document class with a syntax file to enable highlighting whenever you edit a *.pl file.
But today I'm working on a more complicated script with multiple functions. My main requirement is that there be an outline view so I can quickly jump between functions. Read more about Perl has been Eclipsed...
Submitted by dmann on Wed, 09/05/2007 - 15:51
I know using Perl backticks call I can execute an OS command and easily get the output.
I know using Perl system() call I can execute an OS command and easily get the return value.
Today I found out a way to get both.
Pages
