DBD-Oracle Download not availible
Hello, I was very happy as I found your Modul for a connection with the Oracle Database. I tried to download it from www.cpan.org/auhors/id/timb/dbd-oracle-1.12.tar.gz, but the download is not available. I tried this for 3 days. So I contact you in the hope that you can help me. Can you say me where I can get the download else or Can you send me the modul? Your sincerly Andre Jakob [EMAIL PROTECTED]
problem select with char() field on oracle sqlnet
Hello, I work with DBD::Oracle over SQLnet from a solaris server to a Oracle 8 database on a dec alpha server. I can insert my data (numeric and char fields) over the net and select them with sqlplus on the dec server without any problem. However selecting data on the solaris server with DBD::Oracle only works with numeric data - every select statement which uses the char field does return zero rows, but does not indicate an error. Scanning this list and google, I tend to think that this might be a problem of charset converting. In my environment on the solaris server I found no language-relevant settings, for oracle I only use ORACLE_HOME as environment variable, the SID is given in the connect string. Any help would be greatly appreciated Markus
Re: OCI_SUCCESS_WITH_INFO behaviour (Re: ANNOUNCE: DBD::Oracle 1.10)
On Tue, Sep 25, 2001 at 03:10:41PM -0400, Greg Stark wrote: Tim Bunce [EMAIL PROTECTED] writes: On Fri, Sep 21, 2001 at 04:36:13PM -0400, Greg Stark wrote: Oddly, I never received a copy of my own message. This has happened previous times I posted as well but some people on the list responded that they had received my posts and obviously Tim saw it this time. Is there something wrong with the list that would cause people not to see their own posts? Or is there something more substantial wrong such that people are randomly not seeing every message posted? Doubtful. The list management software is very good. Tim.
Re: OCI_SUCCESS_WITH_INFO behaviour (Re: ANNOUNCE: DBD::Oracle 1.10)
On Tue, Sep 25, 2001 at 03:05:47PM -0400, Greg Stark wrote: Tim Bunce [EMAIL PROTECTED] writes: Is this reverting to the previous behaviour? Is there a simply way to recognize this condition? A wrapper function would be fine. Tim. Any chance of answering my other two questions? Will it signal an error, and what will the error look like? Sorry, time is in short supply. I think both were answered by the description in the change log and the natural (documented) implications of it. I'll add a third question, What in heaven's name is the rationale behind signaling an error when the query was executed successfully? At least for Oracle in the cases people have described to me the OCI_SUCCESS_WITH_INFO is telling them something 'serious'. But I'd agree that the behaviour is far from ideal. I'll ponder it in more depth later todo. Tim.
Re: Autocomit and oracle packages
On Wed, Sep 26, 2001 at 03:12:53PM +1200, Dan Horne wrote: Hi all I don't know if this has been discussed on this list before, but I just thought I'd mention it as it took me a while to figure out why my code wasn't working. If you call an Oracle supplied package that requires a commit after being called (such as dbms_alert), Autocommit will not take care of it for you - I guess because it's not a DML statement. To save you having to type commit after all of your other SQL, create a separate connection for the procedure calls, and commit on that handle Odd. Is that behaviour documented by Oracle? Are you using OCI 7 or OCI 8? Can you provide a small self-contained test case? Tim.
Re: DBD-Oracle Download not availible
On Thu, 27 Sep 2001 08:30:35 +0200, andrejakob wrote: I tried to download it from www.cpan.org/auhors/id/timb/dbd-oracle-1.12.tar.gz, but the download is not available. You forgot the t in authors. See if you can find it here: http://www.cpan.org/authors/id/TIMB/ -- Bart.
In Oracle accented characters get dropped if they are at the end of the string
We're having some problems with Oracle and accented characters. When trying to insert certain characters into a field (VARCHAR2). If certain accented characters are entered at the end of the string they get dropped from the string. If we append another character to the end of the string then everything works correctly. Characters with which it occurs are Ï (capital I with an umlaut), ß (german B with a tail - 's' sound), Ò (capital O with an grave accent). We only recently noticed it as it only occurs if the character is at the end of the string. We're using Oracle v8.1.7 thru Apache/Perl 5.6.1/DBI 1.20/DBD::Oracle 1.12 Any help would be greatly appreciated - thanks in advance! Also is there a more appropriate mailing list for this message? Maybe a DBI-Oracle-users mailing list? thanks, Alexis [EMAIL PROTECTED] This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the Head of Technology at Tamar by email ([EMAIL PROTECTED]) or telephone him on 020 8995 7878 and delete the message from your system.
Re: DBD::Pg problems
I'm not familiar with DBD::Pg, so I'm not positive that it supports
placeholders, but if it does you should use them - they will handle
all your quoting for you, and make your code *MUCH* cleaner. Read
up on using placeholders by doing perldoc DBI at the *nix prompt,
or in a windoze DOS prompt window at the DOS prompt.
HTH.
--
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncriticallinux.com
Warren Volz [[EMAIL PROTECTED]] wrote:
I was wondering if anyone had suggestions about the following problem
I am having with DBD::Pg. A script I have is trying to insert the
following statement into a mail table (schema below):
INSERT INTO mail (server_message_num, instance, subject, on_disk,
date, message_id, valid, size, owner, from_addr) VALUES (25, 1, 'RE:
~{'',''b''`''S''n~} ~{''Y''Q~} ~{''\\''b''`''S''n~}!', 'f', 'Mon Sep
10 10:45:48 2001', '[EMAIL PROTECTED]', 't', 5314, 2667,
'Yelena Dandurov
a')
The schema for the table looks like:
CREATE TABLE mail (
message_id CHAR(150) NOT NULL,
server_message_num INTEGER,
instanceINTEGER,
valid BOOL NOT NULL DEFAULT false,--info valid
on_disk BOOL NOT NULL DEFAULT false,
decoded_mimeBOOL NOT NULL DEFAULT false,
owner INTEGER NOT NULL REFERENCES sis_user
(sis_user_id),
last_checkedTIMESTAMP NOT NULL DEFAULT TEXT 'now',
status SMALLINT NOT NULL DEFAULT 0,--read/unread etc
sizeINTEGER,
from_addr VARCHAR(80),
dateTIMESTAMP,
subject VARCHAR(100),
PRIMARY KEY (message_id, owner, instance)
);
Notice the subject which is RE: and a bunch of characters. We use the
quote function to escape the subject, and the insert statement works
fine using the PostgreSQL monitor, but DBD::Pg can't insert it. The
error in the postgres error log is:
Sep 26 16:52:33 x postgres[8884]: [3] ERROR: Bad timestamp
external representation 'Mon Sep 10 10NULLNULL 2001'
I can remove the subject and the insert goes fine... I have a feeling
the driver is having trouble passing the quoted string to the
backend. Any ideas/suggestions?
Thanks,
Warren
Re: DBD-Oracle-1.12 on HP-UX 11
On Wed, Sep 26, 2001 at 07:57:48AM -0500, Jay Strauss wrote: Do a: $ env | sort and post the output BASH=/usr/bin/bash COLUMNS=80 EDITOR=vi HOME=/ HOSTTYPE=hp9000s700 LANG=is_IS.iso88591 LC_NUMERIC=C LINES=25 LOGNAME=root MAIL=/var/mail/root MANPATH=/usr/share/man/%L:/usr/share/man:/usr/contrib/man/%L:/usr/contrib/man:/usr/local/man/%L:/usr/local/man:/opt/upgrade/share/man/%L:/opt/upgrade/share/man:/usr/dt/share/man:/opt/pd/share/man/%L:/opt/pd/share/man:/opt/hparray/share/man/%L:/opt/hparray/share/man:/opt/ignite/share/man/%L:/opt/ignite/share/man:/opt/samba/man:/opt/aCC/share/man/%L:/opt/aCC/share/man:/opt/audio/share/man:/opt/blinklink/share/man:/opt/ansic/share/man/%L:/opt/ansic/share/man:/opt/langtools/share/man/%L:/opt/langtools/share/man:/opt/CC/share/man:/opt/imake/man ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/8.1.7 ORACLE_USERID=scott/tiger@sudda OSTYPE=hpux_9 PATH=/usr/sbin::/usr/sbin:/usr/bin:/sbin:/opt/perl5/bin:/usr/bin:/usr/bin/eroff:/opt/ansic/bin:/usr/ccs/bin:/usr/contrib/bin:/opt/nettladm/bin:/opt/fc/bin:/opt/fcms/bin:/opt/upgrade/bin:/opt/pd/bin:/usr/contrib/bin/X11:/usr/bin/X11:/opt/hparray/bin:/opt/aCC/bin:/opt/CC/bin:/opt/langtools/bin:/opt/imake/bin:/sbin:/home/root:/usr/local/bin:/home/sigpet/notesr4:/opt/java/bin:/usr/sbin:/opt/WP8/wpbin PS1=$LOGNAME@`hostname`:$PWD- PWD=/ SHELL=/sbin/sh SHLVL=1 TERM=vt100 TZ=GMT _=/usr/bin/env -- Rikki. -- HP Technical Support, RHCE, RHCX, HP-UX Certified Admin. -- Solaris 7 Certified Systems and Network Administrator. Bell Labs Unix -- Reach out and grep someone. Those who do not understand Unix are condemned to reinvent it, poorly. -- Rikki. -- RHCE, HP-UX Certified Administrator. -- Solaris 7 Certified Systems and Network Administrator. Bell Labs Unix -- Reach out and grep someone. Those who do not understand Unix are condemned to reinvent it, poorly.
Problem In installing DBI in Win NT machine
Hello I am a beginner in Perl . I have installed Active perl latest version in my Win NT machine. I am trying to install DBI module in my machine by both ppm and manual method. While installing I am facing following problem 1. while trying to install DBI in WIN NT machine by ppm I gave following command ppm ppm Install DBI It gives error: Could not locate a PPD file for the package BDI. Please note during installation internet connection was on and done proxy setting. 2. While trying to install by manual ,i have down loaded DBI madules from CPAN and gave following command perl Makefile.pl nmake it gives error : The name specified is not recognised as an internal or external command,operable program or batch file Please note: In my machine namke is available not dmake Can any body suggest me the remedy for the following problem and how i can install DBI in my window Nt machine Thanking in advance Abhra
Re: DBD-Oracle-1.12 on HP-UX 11
On Wed, Sep 26, 2001 at 08:21:33AM -0400, [EMAIL PROTECTED] wrote: It looks like there is a problem with libjava.sl Do does java work within oracle? Check the Makefile, if -ljava is referenced, try removing it, and see what happens? I had already checked that. there is no -ljava in the makefile. And on the downside, I have to admit to the fact that Im just a simple system administrator here. My knowledge on oracle is exclusivly on the su - c oracle ; svrgmrl ; connect internal ; shutdown immediate level... So I cant tell if java is OK in oracle. I know they havent complained about oracle as far as I know. -- Rikki. -- RHCE, HP-UX Certified Administrator. -- Solaris 7 Certified Systems and Network Administrator. Bell Labs Unix -- Reach out and grep someone. Those who do not understand Unix are condemned to reinvent it, poorly.
Re: DBD::Oracle with Oracle client on Redhat Linux 7.1
On 2001-09-26 14:12:07 -0700, That Jeff Guy wrote: Philip Daggett [EMAIL PROTECTED] writes: I am trying to install DBD::Oracle on a Redhat Linux 7.1 box for the sole purpose of connecting to a remote Oracle server. Oracle is pretty rediculous. They require you to download the entire enterprise package, just to install the client software you need. Also be careful which version you get. Oracle 8.1.7 doesn't seem to like Redhat 7.1 (the installer just hangs shortly after startup), so you will need Oracle 9i, which was only certified for SuSE last time I looked (although the requirements (Kernel 2.4.x and glibc 2.2) are met by RH 7.1, too, so it would probably work). hp -- _ | Peter J. Holzer | My definition of a stupid question is |_|_) | Sysadmin WSR / LUGA | a question that if you're embarassed to | | | [EMAIL PROTECTED]| ask it, you stay stupid. __/ | http://www.hjp.at/ |-- Tim Helck on dbi-users, 2001-07-30 PGP signature
Compatibility of DBI with 8.1.7
Excuse me for my ignorance, but are there any compatibilty problems with DBI and Oracle 8.1.7. I have an application that needs to be moved to an 8.1.7 instance. The current code is set to work with 8.1.6 Thanks Shalini Raghavan
Re: DBD::Oracle with Oracle client on Redhat Linux 7.1
Oracle 9i does work under RedHat, but as someone pointed out to me, in order to work with DBD::Oracle, you need to make sure you also install the Oracle Development Kit as part of that installation. Select the option that says Show all packages including required dependencies and you should see it. The reason 8.1.7 hangs on startup of installation is that it uses glibc 2.1, and Redhat comes with 2.2. There are some compat libs you can download, but I didn't quite get everything working when I did that. 9i will work. -Jeffrey - Original Message - From: Peter J . Holzer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 27, 2001 7:46 AM Subject: Re: DBD::Oracle with Oracle client on Redhat Linux 7.1
Re: Problem In installing DBI in Win NT machine
ppm gets the archive(s) from activestate.com. so, you have to be connected to internet during installation... - Original Message - From: Abhra [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Abhra [EMAIL PROTECTED] Sent: Thursday, September 27, 2001 4:59 PM Subject: Problem In installing DBI in Win NT machine Hello I am a beginner in Perl . I have installed Active perl latest version in my Win NT machine. I am trying to install DBI module in my machine by both ppm and manual method. While installing I am facing following problem 1. while trying to install DBI in WIN NT machine by ppm I gave following command ppm ppm Install DBI It gives error: Could not locate a PPD file for the package BDI. Please note during installation internet connection was on and done proxy setting. 2. While trying to install by manual ,i have down loaded DBI madules from CPAN and gave following command perl Makefile.pl nmake it gives error : The name specified is not recognised as an internal or external command,operable program or batch file Please note: In my machine namke is available not dmake Can any body suggest me the remedy for the following problem and how i can install DBI in my window Nt machine Thanking in advance Abhra
Re: Struggling with inout on a procedure call
Certainly use trace(). Maybe use more generous buffer sizes.
Tim.
On Wed, Sep 26, 2001 at 04:09:30PM -0500, Jones Robert Contr 81 CS/SCK wrote:
Trying to get output from a procedure call. Definitely being a pain. Yes,
yes, I've looked at perldoc DBD::Oracle and that didn't seem to work. I've
even read up on perldoc.com about DBI, and various other websites. Running
out of options.
stats: Windows NT client/server with Oracle 8.1.5 installed, Perl build 629.
use DBI;
$data = 'DBI:Oracle:test2';
$pw= 'xxx';
$login = 'yyy';
$dbh=DBI-connect($data, $login, $pw) || die $dbh-errstr\n;
$ssan = '9';
$cpnt = 'V3OBR13S00';
$xth=$dbh-do(ALTER session set nls_date_format='MMDD') || die
$dbh-errstr\n;
##
## Format: procedure_call(
input,input,input,input,input,output,output,output,output)
## The last 2 inputs can be null for this to work
##
$sth=$dbh-prepare(BEGIN
procedure_call('CURRENT','$ssan','$cpnt','','',:1,:2,:3,:4);
END;) || die $dbh-errstr\n;
$sth-bind_param_inout(1, \$t1,8);
$sth-bind_param_inout(2, \$t2,5);
$sth-bind_param_inout(3, \$t3,10);
$sth-bind_param_inout(4, \$t4,15);
$sth-execute;
$sth-finish;
print $ssan-$cpnt-$t1-$t2-$t3-$t4\n;
$dbh-disconnect;
Robert E. Jones, BSCS, BSP
81 CS/SCK, Keesler AFB
RE: Autocomit and oracle packages
Test case
1. Launch two instances of SQL*PLus. In the first enter
set serverout on size 100
DECLARE
c_alert_nameCONSTANT CHAR(10) := 'test alert';
v_message VARCHAR2(2000);
v_statusNUMBER;
c_wait CONSTANT NUMBER := 60;
v_exit PLS_INTEGER := 0;
BEGIN
-- resgister interest in the alert
dbms_alert.register(c_alert_name);
-- Loop constantly until the alert is received
WHILE (v_exit = 0) LOOP
dbms_alert.waitone(c_alert_name, v_message, v_status, c_wait);
IF (v_status = 0) THEN
dbms_output.put_line('Alert Raised!!!');
dbms_output.put_line('Message: '||substr(v_message,1,200));
v_exit := 1;
ELSE
dbms_output.put_line('No alert raised...');
END IF;
END LOOP;
END;
/
2. In the second enter:
exec dbms_alert.signal('test alert','hello world');
nothing happens
Then enter
commit;
And the alert is recived in the first session.
According to The Oracle 8i Supplied Packages Reference:
Alerts are transaction-based. This means that the waiting session does not
get alerted until the transaction signalling the alert commits. (p 2-1).
dbms_job is transaction based too. I don't know if there are others.
Dan
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 27, 2001 9:31 PM
To: Dan Horne
Cc: [EMAIL PROTECTED]
Subject: Re: Autocomit and oracle packages
On Wed, Sep 26, 2001 at 03:12:53PM +1200, Dan Horne wrote:
Hi all
I don't know if this has been discussed on this list before, but I just
thought I'd mention it as it took me a while to figure out why my code
wasn't working. If you call an Oracle supplied package that requires a
commit after being called (such as dbms_alert), Autocommit will not take
care of it for you - I guess because it's not a DML statement. To save you
having to type commit after all of your other SQL, create a separate
connection for the procedure calls, and commit on that handle
Odd.
Is that behaviour documented by Oracle?
Are you using OCI 7 or OCI 8?
Can you provide a small self-contained test case?
Tim.
Re: In Oracle accented characters get dropped if they are at the end of the string
Information about the NLS settings of the client and server might be helpful. Tim. On Thu, Sep 27, 2001 at 01:30:03PM +0100, Alexis Orssich wrote: We're having some problems with Oracle and accented characters. When trying to insert certain characters into a field (VARCHAR2). If certain accented characters are entered at the end of the string they get dropped from the string. If we append another character to the end of the string then everything works correctly. Characters with which it occurs are Ï (capital I with an umlaut), ß (german B with a tail - 's' sound), Ò (capital O with an grave accent). We only recently noticed it as it only occurs if the character is at the end of the string. We're using Oracle v8.1.7 thru Apache/Perl 5.6.1/DBI 1.20/DBD::Oracle 1.12 Any help would be greatly appreciated - thanks in advance! Also is there a more appropriate mailing list for this message? Maybe a DBI-Oracle-users mailing list? thanks, Alexis [EMAIL PROTECTED] This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the Head of Technology at Tamar by email ([EMAIL PROTECTED]) or telephone him on 020 8995 7878 and delete the message from your system.
OT: tied hashes
This is off topic but I can't find any resources. If anyone
can point me or answer directly I'd appreciate it.
I have a hash tying package that works EXCEPT when references
are returned and used in block constructs like this:
my $h = {};
tie %$h, MyTie;
$h-{KEY} = [];
push(@{$h-{KEY}}, (qw/foo bar/)); # THIS FAILS
The failure is: Can't use an undefined value as an ARRAY reference
If I print the value in FETCH before returning it's there.
If I assign it locally, then use it, it's also there. e.g.,
this does work:
push(@{my $x = $h-{KEY}}, (qw/foo bar/)); # THIS WORKS!
I've built about a half dozen hash ties that follow the same
model and don't exhibit this behavior. I can't include the tie
since it uses a big chuck of other code. I'm just looking for
some general approach to finding the cause.
Sorry for being off topic. Any pointers appreciated.
Steve Sapovits
Global Sports Interactive
Work Email: [EMAIL PROTECTED]
Home Email: [EMAIL PROTECTED]
Work Phone: 610-491-7087
Cell: 610-574-7706
Pager: 877-239-4003
Re: DBD-Oracle-1.12 on HP-UX 11
You gotta set: export PATH=$ORACLE_HOME/bin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib export SHLIB_PATH=$ORACLE_HOME/lib Here's how I do it: cd /opt/perl/src # gunzip -c stable.tar.gz | tar xvf - cd perl-5.6.1 rm Policy.sh config.sh sh Configure -Ubincompat5005 -Dprefix=/opt/perl -Duselargfiles # ## I answered the following questions like: # # What libraries to use? [-lnsl -lnm -lndbm -lmalloc -ldld -lm -lc -lndir -lcrypt # -lsec] # -lcl -lpthread -lnsl -lnm -lndbm -lmalloc -ldld -lm -lc -lndir -lcrypt -ls ec # # Any additional cc flags? [-D_HPUX_SOURCE -Aa] +z -D_HPUX_SOURCE -Aa # # then did a: -d at the next question to accept defaults # make make test make install cd /opt/perl/src gunzip -c DBI-1.19.tar.gz | tar xvf - cd DBI-1.19 perl Makefile.PL make make test make install # export ORACLE_SID=my sid export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/8.1.7 export PATH=$ORACLE_HOME/bin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib export SHLIB_PATH=$ORACLE_HOME/lib export ORACLE_USERID=system/manager cd /opt/perl/src gunzip -c DBD-Oracle-1.08.tar.gz | tar xvf - cd DBD-Oracle-1.08 perl Makefile.PL make test install make test make install - Original Message - From: Richard Allen [EMAIL PROTECTED] To: Jay Strauss [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, September 27, 2001 8:54 AM Subject: Re: DBD-Oracle-1.12 on HP-UX 11 On Wed, Sep 26, 2001 at 07:57:48AM -0500, Jay Strauss wrote: Do a: $ env | sort and post the output BASH=/usr/bin/bash COLUMNS=80 EDITOR=vi HOME=/ HOSTTYPE=hp9000s700 LANG=is_IS.iso88591 LC_NUMERIC=C LINES=25 LOGNAME=root MAIL=/var/mail/root MANPATH=/usr/share/man/%L:/usr/share/man:/usr/contrib/man/%L:/usr/contrib/ma n:/usr/local/man/%L:/usr/local/man:/opt/upgrade/share/man/%L:/opt/upgrade/sh are/man:/usr/dt/share/man:/opt/pd/share/man/%L:/opt/pd/share/man:/opt/hparra y/share/man/%L:/opt/hparray/share/man:/opt/ignite/share/man/%L:/opt/ignite/s hare/man:/opt/samba/man:/opt/aCC/share/man/%L:/opt/aCC/share/man:/opt/audio/ share/man:/opt/blinklink/share/man:/opt/ansic/share/man/%L:/opt/ansic/share/ man:/opt/langtools/share/man/%L:/opt/langtools/share/man:/opt/CC/share/man:/ opt/imake/man ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/8.1.7 ORACLE_USERID=scott/tiger@sudda OSTYPE=hpux_9 PATH=/usr/sbin::/usr/sbin:/usr/bin:/sbin:/opt/perl5/bin:/usr/bin:/usr/bin/er off:/opt/ansic/bin:/usr/ccs/bin:/usr/contrib/bin:/opt/nettladm/bin:/opt/fc/b in:/opt/fcms/bin:/opt/upgrade/bin:/opt/pd/bin:/usr/contrib/bin/X11:/usr/bin/ X11:/opt/hparray/bin:/opt/aCC/bin:/opt/CC/bin:/opt/langtools/bin:/opt/imake/ bin:/sbin:/home/root:/usr/local/bin:/home/sigpet/notesr4:/opt/java/bin:/usr/ sbin:/opt/WP8/wpbin PS1=$LOGNAME@`hostname`:$PWD- PWD=/ SHELL=/sbin/sh SHLVL=1 TERM=vt100 TZ=GMT _=/usr/bin/env -- Rikki. -- HP Technical Support, RHCE, RHCX, HP-UX Certified Admin. -- Solaris 7 Certified Systems and Network Administrator. Bell Labs Unix -- Reach out and grep someone. Those who do not understand Unix are condemned to reinvent it, poorly. -- Rikki. -- RHCE, HP-UX Certified Administrator. -- Solaris 7 Certified Systems and Network Administrator. Bell Labs Unix -- Reach out and grep someone. Those who do not understand Unix are condemned to reinvent it, poorly. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com
Re: DBD::Oracle with Oracle client on Redhat Linux 7.1
On Thu, 27 Sep 2001, Peter J . Holzer wrote: .. Also be careful which version you get. Oracle 8.1.7 doesn't seem to like Redhat 7.1 (the installer just hangs shortly after startup), so you will need Oracle 9i, which was only certified for SuSE last time I looked (although the requirements (Kernel 2.4.x and glibc 2.2) are met by RH 7.1, too, so it would probably work). 9i has just been certified for Red Hat 7.1. The problem with the 8i installer on RH7.x is due to weird interactions between the bundled JVM and glibc-2.2 in RH7.x. I guess you could get the installer working with the new J2EE 1.3.1 FCS release from Sun, using green threads (this is how I got LimeWire working on RH7.x). But then again I have better things to do.. =) still chugging along with 8.0.5.0.0 =) -- Orlando Andico [EMAIL PROTECTED] Mosaic Communications, Inc.
RE: Compatibility of DBI with 8.1.7
We are running OK with Oracle 8.1.7 on a Compaq alpha (Unix 5.1), using DBI-1.20 DBD-Oracle-1.12 There were some issues with building DBD originally as Oracle had rearranged their standard installation directory structure at 8.1.7, but these have all been fixed in the current DBD -Original Message- From: Shalini Raghavan [mailto:[EMAIL PROTECTED]] Sent: Friday, September 28, 2001 6:54 AM To: [EMAIL PROTECTED] Subject: Compatibility of DBI with 8.1.7 Excuse me for my ignorance, but are there any compatibilty problems with DBI and Oracle 8.1.7. I have an application that needs to be moved to an 8.1.7 instance. The current code is set to work with 8.1.6 Thanks Shalini Raghavan CAUTION This e-mail and any files transmitted with it are privileged and confidential information intended for the use of the addressee. The confidentiality and/or privilege in this e-mail is not waived, lost or destroyed if it has been transmitted to you in error. If you have received this e-mail in error you must (a) not disseminate, copy or take any action in reliance on it; (b) please notify Australia Post immediately by return e-mail to the sender; and (c) please delete the original e-mail.
RE: DBD-Oracle-1.12 on HP-UX 11
The reason I asked if java is OK in oracle, is that something is causing dld to try to load the library, with the perl Oracle.sl is loaded. That means that something in Oracle.sl or something IT links with is linked to that library in question. dld, was bitching about the format of the .sl file that it was trying to load... so obvious that library is bad. Perhaps relinking oracle with solve the problem -Original Message- From: Richard Allen [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 27, 2001 9:59 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: DBD-Oracle-1.12 on HP-UX 11 On Wed, Sep 26, 2001 at 08:21:33AM -0400, [EMAIL PROTECTED] wrote: It looks like there is a problem with libjava.sl Do does java work within oracle? Check the Makefile, if -ljava is referenced, try removing it, and see what happens? I had already checked that. there is no -ljava in the makefile. And on the downside, I have to admit to the fact that Im just a simple system administrator here. My knowledge on oracle is exclusivly on the su - c oracle ; svrgmrl ; connect internal ; shutdown immediate level... So I cant tell if java is OK in oracle. I know they havent complained about oracle as far as I know. -- Rikki. -- RHCE, HP-UX Certified Administrator. -- Solaris 7 Certified Systems and Network Administrator. Bell Labs Unix -- Reach out and grep someone. Those who do not understand Unix are condemned to reinvent it, poorly.
Re: Problem In installing DBI in Win NT machine
On 27 Sep 2001, at 19:29, Abhra wrote: Hello I am a beginner in Perl . I have installed Active perl latest version in my Win NT machine. I am trying to install DBI module in my machine by both ppm and manual method. While installing I am facing following problem 1. while trying to install DBI in WIN NT machine by ppm I gave following command ppm ppm Install DBI It gives error: Could not locate a PPD file for the package BDI. Please note during installation internet connection was on and done proxy setting. If the error message was paisted from ppm's output, there was a typo (BDI instead of DBI). Configure your internet connection not to use a http proxy. Note that there is probably software running on your machine acting like a local http proxy and you are not aware of it ( a few months ago i was almost at loss of my senses, because ppm stopped to work without any evident reason, until I discovered that it was my ad filter which I had placed in the startup folder for some reason). If you, for some reason, want to use a http proxy, did you follow the respective instructions in the ppm manual (setting the environment variables HTTP_proxy and probably HTTP_proxy_user and HTTP_proxy_pass)? 2. While trying to install by manual ,i have down loaded DBI madules from CPAN and gave following command perl Makefile.pl nmake it gives error : The name specified is not recognised as an internal or external command,operable program or batch file Please note: In my machine namke is available not dmake You did not tell us after which command you got this error (after the perl Makefile.pl or after the nmake). Check that both are in your path. Have you a got C compiler installed (the DBI contains embedded C code which needs to be copmiled)? Note that it may be necessary to build your whole perl installation from the sources with your compiler... Although it may make one feel somewhat dependent on ActiveState, as soon as you are working with their Perl distribution, always try to install modules with ppm as long as there are ppm packages for it. This is the case for DBI. HTH Bodo
Re: Problem In installing DBI in Win NT machine
On Thu, 27 Sep 2001 19:29:29 +0530, Abhra wrote: 1. while trying to install DBI in WIN NT machine by ppm I gave following command ppm ppm Install DBI It gives error: Could not locate a PPD file for the package BDI. Please note during installation internet connection was on and done proxy setting. You can still use PPM with downloaded archives. You need both a ppd file and the .tar.gz file, the ppd file must point to your local copy of the .tar.gz file (preferably with a relative URL). You can get a ZIP from Activestate's site with both the .tar.gz file (actually, 3 of them -- one for each target platform) and an adjusted ppd file. Unzip (but don't ungzip-untar), and try again from within the directory you unzipped them into. http://www.activestate.com/PPMPackages/zips/6xx-builds-only/ -- Bart.
Re: OT: tied hashes
-- Steve Sapovits [EMAIL PROTECTED] on 09/27/01 11:49:00 -0400
This is off topic but I can't find any resources. If anyone
can point me or answer directly I'd appreciate it.
I have a hash tying package that works EXCEPT when references
are returned and used in block constructs like this:
my $h = {};
tie %$h, MyTie;
$h-{KEY} = [];
push(@{$h-{KEY}}, (qw/foo bar/)); # THIS FAILS
The failure is: Can't use an undefined value as an ARRAY reference
Depends on how you've written the assignment and fetch
operators. The guts of MJD's shared memory handler (IPC::Shared,
I think?) ended up having to use Storable to get around this if
you want a working example.
sl
Re: DBD::Oracle with Oracle client on Redhat Linux 7.1
There are instructions on the Oracle Linux forum on Technet (http://technet.oracle.com) for fixing that problem. it involves installing some libraries which are generally not installed by default and setting an environment variable (it's basically setting up the proper version of libc libraries). On Thu, 27 Sep 2001, Peter J . Holzer wrote: On 2001-09-26 14:12:07 -0700, That Jeff Guy wrote: Philip Daggett [EMAIL PROTECTED] writes: I am trying to install DBD::Oracle on a Redhat Linux 7.1 box for the sole purpose of connecting to a remote Oracle server. Oracle is pretty rediculous. They require you to download the entire enterprise package, just to install the client software you need. Also be careful which version you get. Oracle 8.1.7 doesn't seem to like Redhat 7.1 (the installer just hangs shortly after startup), so you will need Oracle 9i, which was only certified for SuSE last time I looked (although the requirements (Kernel 2.4.x and glibc 2.2) are met by RH 7.1, too, so it would probably work). hp -- -- Cliff NadlerCollective Technologies, Inc. [EMAIL PROTECTED](512)-263-5500 -- To win, you must treat a pressure situation as an opportunity to succeed, not an opportunity to fail Gardner Dickinson
