DBD-Oracle Download not availible

2001-09-27 Thread andrejakob
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

problem select with char() field on oracle sqlnet

2001-09-27 Thread Markus Spring
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

Re: OCI_SUCCESS_WITH_INFO behaviour (Re: ANNOUNCE: DBD::Oracle 1.10)

2001-09-27 Thread Tim Bunce
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

Re: OCI_SUCCESS_WITH_INFO behaviour (Re: ANNOUNCE: DBD::Oracle 1.10)

2001-09-27 Thread Tim Bunce
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

Re: Autocomit and oracle packages

2001-09-27 Thread Tim Bunce
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

Re: DBD-Oracle Download not availible

2001-09-27 Thread Bart Lateur
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

2001-09-27 Thread Alexis Orssich
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

Re: DBD::Pg problems

2001-09-27 Thread Hardy Merrill
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

Re: DBD-Oracle-1.12 on HP-UX 11

2001-09-27 Thread Richard Allen
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

Problem In installing DBI in Win NT machine

2001-09-27 Thread Abhra
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

Re: DBD-Oracle-1.12 on HP-UX 11

2001-09-27 Thread Richard Allen
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

Re: DBD::Oracle with Oracle client on Redhat Linux 7.1

2001-09-27 Thread Peter J . Holzer
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

Compatibility of DBI with 8.1.7

2001-09-27 Thread CCGB
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

2001-09-27 Thread Jeffrey Poore
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

Re: Problem In installing DBI in Win NT machine

2001-09-27 Thread Burak Gursoy
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

Re: Struggling with inout on a procedure call

2001-09-27 Thread Tim Bunce
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.

RE: Autocomit and oracle packages

2001-09-27 Thread Dan Horne
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

Re: In Oracle accented characters get dropped if they are at the end of the string

2001-09-27 Thread Tim Bunce
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

OT: tied hashes

2001-09-27 Thread Steve Sapovits
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} = [];

Re: DBD-Oracle-1.12 on HP-UX 11

2001-09-27 Thread Jay Strauss
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

Re: DBD::Oracle with Oracle client on Redhat Linux 7.1

2001-09-27 Thread Orlando Andico
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

RE: Compatibility of DBI with 8.1.7

2001-09-27 Thread Fox, Michael
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

RE: DBD-Oracle-1.12 on HP-UX 11

2001-09-27 Thread LBaxter
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

Re: Problem In installing DBI in Win NT machine

2001-09-27 Thread eingb
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

Re: Problem In installing DBI in Win NT machine

2001-09-27 Thread Bart Lateur
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

Re: OT: tied hashes

2001-09-27 Thread lembark
-- 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

Re: DBD::Oracle with Oracle client on Redhat Linux 7.1

2001-09-27 Thread Cliff Nadler
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).