experienced the following things useful - on unix/bsd/linux -
sqlplus / EOF
connect sys as sysdba
startup
EOF
things like that can be put into shell scripts - eg as startup scripts, for cron jobs
doing e.g. reports into .pdf's to store on a webserver,
perl's expect will most likely work
Dan,
If I were to use Expect.pm in Perl, I would program in Expect directly. If we
can have one less layer of wrapping, why not? On the other hand, sqlplus is not
an application that insists on terminal input as telnet does. So you can use a
shell here document or coprocess to talk to it; Expect
Jared,
Thanks for correcting me that shutdown is a sqlplus command. I wanted to make
the point that piping strings to sqlplus can do more than Perl DBI can. (But
Perl DBI has advantages in many cases)
Yong Huang
[EMAIL PROTECTED] wrote:
All *SQL* commands will work work with the DBI.
I don't think any UNIX shell has some package or module written for any
database. So the only way to talk to Oracle is using shell as a wrapper around
sqlplus (or any application you developed). In sqlplus, you can use bind
variables easily. In this sense, we can say shell does allow you to use
On Tue, 9 Dec 2003, Yong Huang wrote:
Speaking of Perl versus shell, Perl may still be quite primitive in supporting
two-way communication with an external program e.g. sqlplus. (I have an example
at www.stormloader.com/yonghuang/computer/OracleAndPerl.html#2waytosqlplus
using IPC::Open2).
]
cc:
Subject:RE: PERL?
I don't think any UNIX shell has some package or module written for any
database. So the only way to talk to Oracle is using shell as a wrapper around
sqlplus (or any application you developed). In sqlplus, you can use bind
variables easily. In this sense
I've written one shell script using the coprocess. I don't like using it.
But that's just me.
I think one way of describing ksh (for the male readers out there, anyway)
is that ksh is like the legally blonde girlfriend: There are times when
you wish there was more intelligence there. But she
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: PERL?
I've written one shell script using the coprocess. I don't like using it.
But that's just me.
I think one way of describing ksh (for the male readers out there, anyway)
is that ksh
Oh ... and one more thing ... you can write code in Perl and not have many people
understand it, greatly helps in job security if you are the only one at your work to
know Perl. Okay, it is great, nice and better than many other languages, but now can
you learn this language to obfuscation?
Perl is a full flege programming language, it can
do almost anything such as Java or C++ can do. SQL*Plus or Shell is very limited
in terms of functionalities.
Besides, Perl is portable language. Perl code runs
on almost any platforms.
- Original Message -
From:
KENNETH
Hi
I tend to use PHP (and present the results in a browser or via email) for
scripts that fall outside the scope of (PL/)SQL.
I have never had a serious look at Perl, is there any website(s) that can
give a clear explanation of the pro's con's of both?
The reason I choose PHP was the ease of
what do you mean by sophisticated I/O?
From: Cary Millsap [EMAIL PROTECTED]
Date: 2003/12/07 Sun PM 11:59:25 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: PERL?
You'll get much more comprehensive answers than mine, but a few huge
motives for me
by sophisticated I/O?
From: Cary Millsap [EMAIL PROTECTED]
Date: 2003/12/07 Sun PM 11:59:25 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: PERL?
You'll get much more comprehensive answers than mine, but a few huge
motives for me are.
- You
PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Monday, December 08, 2003
7:09 AM
To: Multiple recipients of list
ORACLE-L
Subject: Re: RE: PERL?
Youll get much
more comprehensive answers than mine, but a few huge motives for me are
- You cant do I/Oespecially
- Visit www.hotsos.com for schedule
details...
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Eric
King
Sent: Monday, December 08, 2003
6:39 AM
To: Multiple recipients of list
ORACLE-L
Subject: Re: PERL?
Perl is a full flege programming
language
The difference that has affected me the most in writing utility scripts is
that PERL can talk to the database like using a telephone. Ksh must talk
like using a walkie-talkie; that is, each side of the conversation must talk
then release the push-to-talk (PTT) button before the other side can
Hey Mladen,
Weren't you going to be taking a look at Python too? (Around
Thanksgiving as I recall.) I'd be interested in your feedback on it as
well.
My take is that Python is powerful yet easy to learn, it's much more
productive than Java and is still quite scalable. Like Perl it's a great
al Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cary
MillsapSent: Monday, December 08, 2003 9:00 AMTo: Multiple
recipients of list ORACLE-LSubject: RE: PERL?
The only thing I
think I disagree with is the word almost.
Cary
MillsapHotsos
Enterprises
Title: Message
Then PERL should also run
on a TIVO box - it usesLinux.
Ken Janusz,
CPIM
- Original Message -
From:
Orr, Steve
To: Multiple recipients of list ORACLE-L
Sent: Monday, December 08, 2003 10:24
AM
Subject: RE: PERL?
Well
I might have
I was. Unfortunately, I'm struggling with something called OpenLDAP,
which was determined to be of even higher priority then Python.
On 12/08/2003 11:14:33 AM, Orr, Steve wrote:
Hey Mladen,
Weren't you going to be taking a look at Python too? (Around
Thanksgiving as I recall.) I'd be
echo s='Perl is portable';print s.replace('Perl','Python')+'
too!'|python
-Original Message-
KENNETH JANUSZ
Sent: Monday, December 08, 2003 9:39 AM
To: Multiple recipients of list ORACLE-L
Then PERL should also run on a TIVO box - it uses Linux.
Ken Janusz, CPIM
- Original Message
Title: Message
It
does.
-Original Message-From: KENNETH JANUSZ
[mailto:[EMAIL PROTECTED]Sent: Monday, December 08, 2003 11:39
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
PERL?
Then PERL should also run
on a TIVO box - it usesLinux.
Ken Janusz,
CPIM
echo Python is portable|perl -e '$X=;chomp($X); print $X but it is much harder
to write obfuscated code in Python\n;'
On 12/08/2003 11:59:35 AM, Orr, Steve wrote:
echo s='Perl is portable';print s.replace('Perl','Python')+'
too!'|python
-Original Message-
KENNETH JANUSZ
Sent:
Can you install Oracle 9.2 on a playstation 2?
On 12/08/2003 12:04:26 PM, Bobak, Mark wrote:
It does.
-Original Message-
Sent: Monday, December 08, 2003 11:39 AM
To: Multiple recipients of list ORACLE-L
Then PERL should also run on a TIVO box - it uses Linux.
Ken Janusz,
One BIG advantage of Perl is DBI. Via shell you can't use bind variables
which sometimes come in handy. An admin dweeb here developed a
monitoring shell script that executed 5500 queries an hour each using
literals instead of bind variables resulting in shared pool
fragmentation and server errors.
Don't know why not. Using the here document anything you can type in on
the sqlplus command line can be entered with ksh ... including the defining
of bind variables.
-Original Message-
Via shell you can't use bind variables
which sometimes come in handy.
--
Please see the official
#!/usr/bin/ksh
sqlplus -s -XXX
joecool/jomama
var xyz char(50)
var abc char(50)
begin
:xyz := 'HELLO WORLD';
select :xyz into :abc from dual;
end;
/
print abc
XXX
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
If the rest works, the JDBC thin client oughtta work, too.
I wonder if anyone's bothered for some unholy reason to try Oracle server in
WineX... :)
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
Youll get much more comprehensive
answers than mine, but a few huge motives for me are
-
You cant do I/Oespecially
sophisticated interactive I/Oconveniently in SQL*Plus or PL/SQL.
-
More generally, SQL
restricts your viewpoint to whats inside the database. As a performance
analyst, I
Perl is a general purpose interpreted programming language, written specifically with
reporting
purpose in mind. In fact, perl stands for Practical Extraction/Reporting Language.
That means
that perl is excellent for producing all kinds of reports. In fact, it has a part
called formats which
I agree ... the lack of SP in mysql (soon to be released in the new
version) is really not acceptable ... this is going to really help !!
Not that I use mysql or anything ... really ... honest ... :)
(oh smeg!!)
-Original Message-
DENNIS WILLIAMS
Sent: Tuesday, December 02, 2003 8:00 PM
This isn't new: am I missing something here?
DENNIS WILLIAMS [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/02/2003 07:59 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Perl / MySQL
Now we know MySQL is
Yes, there are compatibility issues. ActiveState does not keep their
DBD::oracle up to date. The second hand reason I've been given
is the believe there are some licensing issues, but as the Oracle libs
are not linked in, I don't know what they mean.
try ftp://ftp.esoftmatic.com/outgoing/DBI
I'm in the process of doing the same thing. You can go to
http://www.cmve.net/~merijn for a compiled version of Perl 5.8.1 that is
prepared from DBI and DBD::Oracle. That will save you from compiling it
yourself. My understanding is that you will still need gcc (or the HP ansi
compiler) to compile
System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
-Original Message-
From: Keith Moore [mailto:[EMAIL PROTECTED]
Sent: Friday, October 03, 2003 10:05 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: perl dbi dbd
I'm in the process
Well, it's not at http://hpux.cs.utah.edu/, so I'm not sure where you can
get it. Are you sure you can't build it? It'll build with the icky
non-ANSI cc that comes with HP/UX (I think). Or d/l a gcc binary depot from
the above site and compile it with that.
There is at least one major caveat
HP has pretty good customer service. They have usenet discussion
forums on which they readily help. I'm sure that a question like
would not take HP long time to answer.
On 2003.10.03 00:34, Jesse, Rich wrote:
Well, it's not at http://hpux.cs.utah.edu/, so I'm not sure where you can
get it. Are
check http://www.dba-village.com/dba/village/dvp_scripts.ScriptDetails?ScrId=993
- Original Message -
From:
AK
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, August 27, 2003 10:44
PM
Subject: perl/shell script for alert
log
I am sure you guys
HTH
#!/bin/sh
# This Script search for Oracle error messages in last
100 lines in the alert log file ,
# keep log to a file.
# You should pass name of ORACLE_SID as a parameter.
#!/usr/bin/sh
#
# Comments: Script checks last 100 lines of
# the alert log for specific
# Oracle errors, e-mails
http://www.oracledba.co.uk/
Check out the alert log script in the admin section. Doesn't
repeatedly check the same segment of the alert log file.
- Ethan
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Wednesday, August 27, 2003 12:14
PMTo: Multiple
AK - Go to Google and search on oracle alert log monitor script. This will
give you an array to select from. What you want will depend to a large
extent on your requirements:
- Something you can easily modify?
- What platforms should it run on?
- Email you alerts?
- Which errors do you wish to
When I grep something from the alert log,
it never tell me the date and time of the error.
Is there a setting for appending a timestamp on each error?
-Original Message-
Sent: Wednesday, August 27, 2003 1:35 PM
To: Multiple recipients of list ORACLE-L
HTH
#!/bin/sh
# This Script search
If you use Connor's script you can modify it to send you the entire chunk of
file it is currently checking in the body of the email. Ideally you are
checking at a frequent interval so the time of the alert is usually about
the same time you get the error message.
One enhancement I suggest to
Welcome back Ethan!
An alternative is using the following lines in init.ora:
event=1555 trace name errorstack level 3
event=4031 trace name errorstack level 3
event=1652 trace name processstate level 10
This catches the dreaded 01555, out of TEMP, and shared pool allocation
errors *along* with
Hi!
I would add a check for Checkpoint not complete in alert just in case as
well.
Tanel.
One enhancement I suggest to every script is to configure the a
SERVERERROR
trigger to throw certain errors out to the alert log. ORA-1555 is one
that
will show up at the session level but not at the
Hey, awesome tip! Been here, lurking. Does that generate a trace file with
more than just session id and serial# in it? Nice thing about SERVERERROR
is I can get machinename, username, osuser etc and stuff it in alert log
so I see who caused the error when I get the email, but your way is
Yeah, I log those. Some of the db's I support run with very small redo logs
and I can't change. They get those quite frequently at times so I pretty
much ignore them. My script also reacts (log,email,page, or run some
script) in the event of startups, shutdowns and alter database structure.
It
O'reilly perl in a nutshell
-Mensaje original-
De: Bala Regupathy [mailto:[EMAIL PROTECTED]
Enviado el: viernes, 08 de agosto de 2003 16:34
Para: Multiple recipients of list ORACLE-L
Asunto: PERL reference
Pardon me if you have already come across this, can anyone please suggest a
Title: RE: PERL reference
The Deitel and Deitel book PERL: How to Program is the top rated PERL book on Amazon. Just got it myself but can't offer an opinion yet. I know it's used by the local technical college for their PERL class. It's cheaper at www.bookpool.com.
1. Perl How to Program
]bcc:
Subject:
RE: PERL reference
Learning Perl from O'Reilly:
http://www.oreilly.com/catalog/lperl3/
US $21.50 from bookpool.com:
http://www.bookpool.com/.x/n6ardwv1ni/sm/0596001320
Got me going enough to start writing an OEM replacement in Perl/Tk. I
didn't say it was *good*...(or finished). :)
Rich
Rich Jesse
Jared,
You came to the same conclusion I did. Since this is
the first perl script I have written for production I
still have a lot to learn. I was thinking that I had
missed something painfully obvious.
Thanks for the help. Hope all is well by you.
Pete
--- [EMAIL PROTECTED] wrote:
Pete,
Pete,
Even as a rabid Perl fanatic, I still use KSH to install statspack.
I just modified the stock scripts a bit so they will run without user
input.
You can do it in Perl, but ksh is probably the tool for this job.
Jared
Peter Barnett [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
not a guru Chris? me thinks you sell yourself short. i like both solutions
- very nice and TMTOWTDI!
and Tim's coming soon to a module near you: execute_array() was nice too ;)
hopefully that answers the original posters question.
-Original Message-
Sent: Tuesday, July 01, 2003 6:05
As long as you are using bind variables,
the overhead of multiple executes should
not be very high.
It's all a matter of degree. On several trace files I've analyzed lately,
the whole response time problem was caused by thousands of 'SQL*Net message
from client' calls. They had nice little
if i get you right - you're trying to treat the resultset from a query as an
array in Perl. That's the way it works. Try something like this:
$sth = $dbh-prepare ( select tab1.col1, tab2.col2 from tab1, tab2
where tab1.ID1 = tab2.ID2
and tab1.X = ? );
my $resultset =
No. I want to reduce the numebr of sql calls.
For example,
@my_array = (1,2,3);
I don't want to do
select tab1.col1, tab2.col2 from tab1, tab2
where tab1.ID1 = tab2.ID2
and tab1.X = 1;
select tab1.col1, tab2.col2 from tab1, tab2
where tab1.ID1 = tab2.ID2
and
ok - that makes more sense. sorry for misinterpreting the question. i've
never done it, but my first instinct would be to explore using an in clause
in the query -
select tab1.col1, tab2.col2 from tab1, tab2
where tab1.ID1 = tab2.ID2
and tab1.X in (1, 2, 3)
can you simply
oops! My apologies for not posting the solution to the list. Thanks
for covering for my oversight Jared. *sheepish grin*
Dwayne
Jared Still wrote:
FYI, if any of you are using the dbup.pl script
from the PDBA toolkit:
The solution to Dwayne's problem was to change
the following line in
not sure if this is what you want. one sql call
select tab1.col1, tab2.col2 from tab1, tab2
where tab1.ID1 = tab2.ID2
and tab1.X = ?
and tab1.X = ?
and tab1.X = ?
;
@my_array = (1,2,3);
sth-execute(@my_array);
On Tue, 1 Jul 2003, Guang Mei wrote:
No. I want to reduce the numebr of
Responses to 2 emails below:
Alex wrote:
not sure if this is what you want. one sql call
select tab1.col1, tab2.col2 from tab1, tab2
where tab1.ID1 = tab2.ID2
and tab1.X = ?
and tab1.X = ?
and tab1.X = ?
;
@my_array = (1,2,3);
sth-execute(@my_array);
Errm, no rows will
FYI, if any of you are using the dbup.pl script
from the PDBA toolkit:
The solution to Dwayne's problem was to change
the following line in dbup.conf from this:
%onCallList = ( 'default' = 'corpdba' );
to this:
%onCallList = (
'20030101' = 'corpdba',
'default' = 'corpdba'
Dwayne,
Offhand, I would say that the problem is due to the pager attribute
being empty in the %addresses hash.
Try putting a value in it.
Also, what is line 597 in dbup.pl? Yours is likely
a few lines different than mine.
Please show it in context. ie. with surrounding lines as well.
Jared
Hi Jared,
Kudos on such a great book!
Below is my entire file. I did try it with the pager field filled
but I had the same result.
Again, pardon the long email. And thanks for taking a look at this.
Here is the function containing line 597 of dbup.pl:
sub getDba {
my $self = shift;
It would be sort of cool to have things like direct insert (append hint),
bulk collect into, varray - perl array mapping and alike in Perl. That
would
be much more useful then flogging a dead horse like Oracle7. I don't use
oraperl
syntax for ages now. All my reports are using DBD syntax.
I couldn't support you more Tim.
-Original Message-
Sent: Monday, March 31, 2003 6:54 PM
To: Multiple recipients of list ORACLE-L
Oraperl?
I released DBD::Oracle 1.14 a few days ago.
In the release notes I said:
NOTE: OCI 7 and Oraperl will not be supported in future releases.
I'm
:
Subject:
RE: Perl
04/01/03 10:18 AMDBD::Oracle - discontinuing support
for Oracle 7 and Ora
Please respond
Tim,
Personally, I have a few v7 db's around. My DBD interaction with them
however
is limited to logging on to the database just to make sure it's still up.
Would removing OCI7 support include removing the ability to logon to a v7
db?
Jared
Tim Bunce [EMAIL PROTECTED]
Sent by: [EMAIL
:
bcc:
Subject:
RE: Perl
On Tue, Apr 01, 2003 at 10:08:31AM -0800, [EMAIL PROTECTED] wrote:
Tim,
Personally, I have a few v7 db's around. My DBD interaction with them
however
is limited to logging on to the database just to make sure it's still up.
Would removing OCI7 support include removing the ability to
:
Sent by: Subject: Re: Perl DBD::Oracle -
discontinuing support for Oracle 7 and Oraperl?
[EMAIL PROTECTED
Do you
know if this book covers the Perl basics or does it assume you know Perl
Already. "Larry Hahn" [EMAIL PROTECTED]
3/13/03 9:39:02 AM
Jeffrey,
I am emailing you
direct because my reply to the list is not going through.
I have heard a lot
about the following book:Perl for
Title: Message
Jeffrey,
A pretty good reference is:
Programming the Perl DBI by Descartes
Bunce (O'Reilly Associates)
It has been very helpful to me!
Cheers!
Bill
Bill TantzenUniversity of Minnesota
Libraries[EMAIL PROTECTED]612-626-9949 (office) 612-250-6125
Jeffrey,
Jared is a member (and owner of) this list - why not shoot him a message?
I'm sure he wouldn't mind ;)
[EMAIL PROTECTED]
Mark
-Original Message-
Beckstrom
Sent: 13 March 2003 14:59
To: Multiple recipients of list ORACLE-L
Do you know if this book covers the Perl basics or
The book is not a tutorial for Perl, but the first chapter includes
What is Perl?, so not *too* much is assumed.
The appendices are very good for beginners. containing four
'Essential Guides' to Perl.
Jared
On Thursday 13 March 2003 06:54, Jeffrey Beckstrom wrote:
Do you know if this book
I have heard some raving reviews for the
book
Perl for Oracle DBAs
By AndyDuncan,JaredStillAugust
2002 0-596-00210-6, Order Number: 2106
[Jack van
Zanen]
-Original
Message-From: Jeffrey Beckstrom
[mailto:[EMAIL PROTECTED]Sent: donderdag 13 maart 2003
15:04To: Multiple
Do you know if this book covers the Perl basics or does it assume you know Perl
Already.
Larry Hahn [EMAIL PROTECTED] 3/13/03 9:39:02 AM
st1\:*{behavior:url(#default#ieooui) }Jeffrey, I am emailing you direct because my
reply to the list is not going through. I have heard a lot about the
http://www.oreilly.com/catalog/oracleperl/
Play your cards right and you may even get
an autographed copy. ;o)
Dave
-Original Message-From: Jeffrey Beckstrom
[mailto:[EMAIL PROTECTED]Sent: Thursday, March 13, 2003 8:04
AMTo: Multiple recipients of list ORACLE-LSubject: OTC:
Programming the Perl DBI from Oreilly is
really good for your need.
-Original Message-
From: Farnsworth, Dave
[mailto:[EMAIL PROTECTED]
Sent: Thursday, March 13, 2003
8:59 AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Perl Book
http://www.oreilly.com
Get DBI and DBD::Oracle from www.xmlproj.com/PPM, courtesy of Ilya Sterin.
Jared
Jeffrey Beckstrom [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
03/11/2003 06:34 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
On Thu, Mar 06, 2003 at 02:54:19PM -0800, [EMAIL PROTECTED] wrote:
1) fetchrow_arrayref is faster than fetchrow_array, as Alex has noted.
2) I see you've already set RowCacheSize. Anecdotal evidence ( not just mine)
suggests that the diminished returns obtained by setting this 100 aren't
Thanks Tim.
I'll have to play with that code a bit.
Jared
On Friday 07 March 2003 07:09, Tim Bunce wrote:
On Thu, Mar 06, 2003 at 02:54:19PM -0800, [EMAIL PROTECTED] wrote:
1) fetchrow_arrayref is faster than fetchrow_array, as Alex has noted.
2) I see you've already set RowCacheSize.
million rows. So I won't use fetchall_arrayref.
Thanks for your help.
Guang
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: Thursday, March 06, 2003 5:54 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: perl DBI question
try using fetchrow_arrayref and see if its faster or less resource
intensive.
On Thu, 6 Mar 2003, gmei wrote:
I have some perl code which selects table data and write it into a file. I
have something like:
---
$dbh-{RowCacheSize} = 1;
open(DATA, $tn) || die Can't open file\n;
:
Subject:Re: perl DBI question: fetchrow_array
try using fetchrow_arrayref and see if its faster or less resource
intensive.
On Thu, 6 Mar 2003, gmei wrote:
I have some perl code which selects table data and write it into a file.
I
have something like:
---
$dbh
PROTECTED]
cc:
Subject:RE: Perl Modules
Thanks for the info!
I found DBD::Oracle on cpan.org, but when I downloaded it and unzipped it,
it
gave me .c and .h files. I read in the install guide that if it came down
with that, I had to compile it on my own with a C compiler
I'd say start with DBI and the DBD for ORACLE. to be found at CPAN.Thread trough, but
its easy. Look out for matching versions. Some have prerequisites.Then check the
manpages coming with these things. man DBD, man DBI,...
hope it as useful - used to get them this way before I started using the
search.cpan.org
look for database or oracle or dbi
On Tue, 25 Feb 2003, sstefick wrote:
I've done some basic Perl programming for UNIX Sys admin kinda tasks, but now
I'm looking to get more into the DB functionality of it. I was wondering if
anyone could give me a list of Perl Modules I
Required:
DBI
DBD::Oracle
After that, check out http://search.cpan.org/modlist/Database_Interfaces
and see what strikes your fancy.
I've recently installed DBI::Chart along with GD and other supporting
modules to create charts from YappPack data derived from statspack
data. Very nice to have
In addition to DBI and DBD::Oracle, which allows you to access Oracle
databases directly, we have found MIME::Lite very useful. It allows us to
create and send e-mail messages with attachments and make use of HTML in the
message formatting. With MIME::Lite, your monitoring processes can send you
On Wed, Feb 26, 2003 at 09:39:32AM -0800, [EMAIL PROTECTED] wrote:
Required:
DBI
DBD::Oracle
After that, check out http://search.cpan.org/modlist/Database_Interfaces
and see what strikes your fancy.
The http://search.cpan.org/modlist/... path just lists what's in the official Module
Thanks for the info!
I found DBD::Oracle on cpan.org, but when I downloaded it and unzipped it, it
gave me .c and .h files. I read in the install guide that if it came down
with that, I had to compile it on my own with a C compiler. I don't have a C
compiler on my machine. I also tried to
stefick,
i have attached DBD::Oracle which u can install with PPM.
hope u are looking for this.
Regards,
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
Hi Charlie
Can u pls. send me the publisher name or any more details about this book,
as I am new Oracle DBA field.
I am very thankful to u for this co-operation.
Thanks
Lucky
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, February 14,
: Wednesday, February 19, 2003 12:00 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Perl for Oracle DBA
Hi Charlie
Can u pls. send me the publisher name or any more details
about this book,
as I am new Oracle DBA field.
I am very thankful to u for this co-operation.
Thanks
:
Subject:RE: Perl for Oracle DBA
Perl for Oracle DBAs
By Andy Duncan, Jared Still
Publisher : O'Reilly
Pub Date : August 2002
ISBN : 0-596-00210-6
Pages : 620
Their next book will be .NET for an Oracle DBA, so called bigfoot
book
-Original Message-
From: Lucky Sharma
:
Subject:RE: Perl for Oracle DBA
Perl for Oracle DBAs
By Andy Duncan, Jared Still
Publisher : O'Reilly
Pub Date : August 2002
ISBN : 0-596-00210-6
Pages : 620
Their next book will be .NET for an Oracle DBA, so called bigfoot
book
-Original Message-
From: Lucky Sharma
I concur. I've already recommended the book, this is
a good opportunity to re-iterate my recommendation.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Friday, February 14, 2003 11:35 AM
To: Multiple recipients of list ORACLE-L
Subject: Perl for Oracle
Title: RE: Perl
Okay ... a question from a colleague ...
How do you get python to work with Oracle ... for perl there DBD: and DBI: anything similar in Python? My knowledge of Perl is as good as my knowledge of Python ... /dev/null
Raj
Hi,
the issue of database access from python is addressed here :
http://www.python.org/topics/database/
http://www.python.org/topics/database/
with specific modules (incliuding Oracle) listed here :
http://www.python.org/topics/database/modules.html
1 - 100 of 216 matches
Mail list logo