Re: [Dbdpg-general] Re: Data types mapping - Postgresql

2003-08-18 Thread David Wheeler
On Monday, August 18, 2003, at 04:47 PM, Rudy Lippan wrote: Okay here it is: http://www.remotelinux.com/rlippan/DBD-Pg-1.31_3.tar.gz Looks good to me. What's to keep us from putting this on CPAN? mercury% make test PERL_DL_NONLAZY=1 /usr/local/bin/perl "-MExtUtils::Command::MM" "-e" "test_harn

PLS-00553: character set name is not recognized

2003-08-18 Thread Ian Jones
We've been getting the following error when calling an oracle stored procedure (including a bindparam in the call) using DBD-Oracle. The error doesn't occur every time. Has anyone seen this before? Is it really a character set error, or can it just not output the real error text. Thanks. DBD::

Re: [Dbdpg-general] Re: Data types mapping - Postgresql

2003-08-18 Thread Rudy Lippan
On Sun, 17 Aug 2003, Rudy Lippan wrote: > On Sun, 17 Aug 2003, Bruce Momjian wrote: > > > Date: Sun, 17 Aug 2003 01:26:33 -0400 (EDT) > > From: Bruce Momjian <[EMAIL PROTECTED]> > > To: Tim Bunce <[EMAIL PROTECTED]> > > Cc: Doug Silver <[EMAIL PROTECTED]>, [EMAIL PROTECTED], > > DBD-pg <[EMAI

LongReadLen problem with clobs

2003-08-18 Thread John MccLain
Here is my code: use DBI; $dbh = DBI->connect('DBI:ODBC:LNX1', 'nsite', 'nsite', {LongReadLen => 2, LongTruncOk => 1}); $dbh->{LongReadLen} = 20; $dbh->{LongTruncOk} = 1; #$selstmt = "SELECT NOTE_TEMPLATE_TXT from NOTE_TEMPLATE"; #selstmt1: NOTE_TEMP

Re: Performance Suggestions

2003-08-18 Thread Michael A Chase
> Working with an Oracle database, there are several ways to fetch rows > from table. In terms of performance which best? Here is a snippet from > an existing script, are there ways to improve it? If you can, it is usually most effecient to handle one row at a time. Perl puts a lot of effort and

RE: Error installing DBD::Oracle 1.14 on HP-UX 11.0

2003-08-18 Thread alsalvo
> At line 1338, change hpux_libdir to main::hpux_libdir Did that. That solved the problem with the makefile. Thanks. Now I'm getting this error when I try to compile. ld: Unrecognized argument: -Wl,+s ld: Usage: ld [options] [flags] files *** Error exit code 1 I've applied a patch from another

SUMMARY - Strange connect problem using DBI

2003-08-18 Thread Julian Rogan
{\rtf1\ansi\deff0{\fonttbl{\f0\fmodern\fcharset0 Courier New;}} {\colortbl ;\red0\green0\blue0;} \viewkind4\uc1\pard\cf1\lang1033\f0\fs20 Hi,\par I \protect did \cf0 not get a solution to my problem however I did get a workaround from\par Mark LoBue:\par \par "This all sounds like environment issue

RE: Error installing DBD::Oracle 1.14 on HP-UX 11.0

2003-08-18 Thread KIDDER, ERIC J (SBCSI)
> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, August 18, 2003 9:41 AM > > The am receiving the following error when I run "perl Makefile.PL" > > Use of inherited AUTOLOAD for non-method MY::hpux_libdir() is > deprecated > at Makefile.PL line 1

Error installing DBD::Oracle 1.14 on HP-UX 11.0

2003-08-18 Thread alsalvo
The am receiving the following error when I run "perl Makefile.PL" Use of inherited AUTOLOAD for non-method MY::hpux_libdir() is deprecated at Makefile.PL line 1338. MY doesn't contain an __DATA__ token at Makefile.PL line 1338 Any ideas about what the problem is here Thanks in advance. Aaron