On Monday, September 9, 2002, at 06:11 PM, Jeff Urlwin wrote:
> From perldoc DBI:
>
> If the subroutine returns a false value then the "RaiseError"
> and/or
> "PrintError" attributes are checked and acted upon as normal.
>
> I read that as if the subroutine returns non-false values,
>
> On Monday, September 9, 2002, at 03:16 PM, Jeff Urlwin wrote:
>
> > Not specifically, but maybe I'm missing something. If HandleError is
> > called, shouldn't the result of $attr->{HandleError} be checked before
> > trying to RaiseError or PrintError?
>
> AFAIK, HandleError isn't expected to
Sorry -- first of all, please keep dbi-users on the mailing cc line or the
to line. Others may see something I don't or be able to offer help that I
can't.
Since you are using ? for the place holders, you need to bind_param(N,,
) where N is the numerical order for the ?. I.e.
$
Not to sure what your function tims.get_all_curr_descs_items looks like, but
this (simple but possibly dumb) example worked for me:
use strict;
use warnings;
use DBI;
use DBD::Oracle qw(:ora_types);
my $dbh;
my $username='';
my $password='';
$ENV{ORACLE_SID}='dwhx01';
my $dsn="dbi:Orac
On Monday, September 9, 2002, at 03:16 PM, Jeff Urlwin wrote:
> Not specifically, but maybe I'm missing something. If HandleError is
> called, shouldn't the result of $attr->{HandleError} be checked before
> trying to RaiseError or PrintError?
AFAIK, HandleError isn't expected to return someth
On Monday, September 9, 2002, at 02:49 PM, Tim Bunce wrote:
> I'm comfortable with leaving those unchanged. I see them as
> preconditions.
> Anyone else got a view?
Welcome back, Tim! Hope you had a nice vacation.
My view (if I may be so bold as to speak up once again) is that, if
want excep
Check out the NAME and NAME_uc attributes associated with
the statement handle. They essentially give you a hash of
column names.
Steve Sapovits
[EMAIL PROTECTED]
> -Original Message-
> From: Kyle [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, September 09, 2002 5:04 PM
> To: PERL DBI
>
> On Wed, Aug 21, 2002 at 09:59:23PM -0700, David Wheeler wrote:
> > Hi All,
> >
> > I'd like to submit a simple patch that causes the DBI connect() method
> > to execute a HandleError code reference if it has one. There's a
> > comment suggesting that it could be added, and it makes sense to me
Yes, access is sometimes quirky about longs/memos. Try doing this (in
pseudo code) (warning, may wrap long lines):
#!perl -w
# above line makes sure perl is running with warnings.
use strict; # make sure we have strict on to check for dumb typos
use DBI qw(:sql_typ
Hi Tim. Welcome back! Hope your vacation was wonderful.
I sent this a couple of days ago knowing you were gone, and I'm sending
it now because I see your back and I know you deleted all of the
dbi-users mail. :-)
I'm trying make DBD::Oracle on Macintosh OS X.
DBI-1.30 compiled and tested clea
On Wed, Aug 21, 2002 at 09:59:23PM -0700, David Wheeler wrote:
> Hi All,
>
> I'd like to submit a simple patch that causes the DBI connect() method
> to execute a HandleError code reference if it has one. There's a
> comment suggesting that it could be added, and it makes sense to me, so
> I s
http:[EMAIL PROTECTED]/msg00111.html
http:[EMAIL PROTECTED]/msg12852.html
Tim.
On Sun, Sep 29, 2002 at 03:16:23PM -0700, [EMAIL PROTECTED] wrote:
> Hello,
>
> In an attempt to add some custom logging into DBI calls, I have over-ridden
> the execute method of DBI with a custom execute method.
SQL_BIGINT is no longer exported by the DBI, try just deleting the two
lines in JDBC.pm that use it.
Tim.
On Fri, Aug 30, 2002 at 12:11:56PM -0500, Marc Francoeur wrote:
> Set up DBD::JDBC to use a (god help me) a Microsoft supplied JDBC driver
> for MS SQL Server 2000. Can't seem to get past t
On Mon, Sep 09, 2002 at 05:03:48PM -0400, Kyle wrote:
> Hello
>
> How can I get SQL to return the column names when doing a select using
> the DBI?
>
> Why do I need this? I am trying to make one sub that will do my various
> selects. Right now I'm doing it with discrete subs. I find that the
Hello
How can I get SQL to return the column names when doing a select using
the DBI?
Why do I need this? I am trying to make one sub that will do my various
selects. Right now I'm doing it with discrete subs. I find that these
subs are EXACTLY the same except for parsing the SQL returns by t
Brad,
What version of DBD::ODBC are you using? If you are using DBD::ODBC 0.28
from ActiveState, then I suggest upgrading to the latest (which has a PPM
file at ftp://ftp.esoftmatic.com/pub/outgoing/DBI
Please upgrade your DBI too, as you must use the version I have uploaded
there.
Regards,
J
Hi Patrick,
Yes it is very possible. We use HP Openview and we access the DB via a
perl script to get information for our Notification process. The Openview
DB is an Oracle DB, while the NNM DB - which you also get with Openview -
is a solid DB. We don't do much with the NNM DB.
The ORACLE_SID
Hello,
I want to use PERL to get informations from a database of HP Open View. Its a Solid or
Oracle database.
Does anyone know if its possible to access this database of HP Open View ???
I know that there are DBIs for SOLID and ORACLE. But is it possible with HP Open View
???
Thanks Patrick
Scenario:
I am using the following code to update an Access database. The fields
case_notes1...case_notes4 are MEMO fields. Sometimes, I have no
problem whatsoever. Other times, I get the following error:
DBD::ODBC::st execute failed: [Microsoft][ODBC Microsoft Access
Driver]Invalid precis
On Monday, September 9, 2002, at 01:03 AM, Raffaele Conte wrote:
> I have a problem with he installation of DBD-pg 1.13 on Mac. The make
> works fine but when I run "make test" this is the result:
It looks like Perl is having trouble finding your SSL library. Where is
it located? Make sure th
I am loading DBD::Informix on hpux 11.0. Unfortunately Perl is installed for 32 bit
os, now when I type make it gives me the following error:
LD_RUN_PATH="" ld -o blib/arch/auto/DBD/Informix/Informix.sl -b Informix.o dbdimp.o
dbdattr.o sqltoken.o sqltype.o ixblob.o decsci.o odbctype.o link.o
What character set is your Oracle session using? Sounds like Oracle is
stripping characters out. What does a trace reveal?
-Original Message-
From: Vorce, Tim (T.) [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 09, 2002 09:26
To: dbi users perl.org
Subject: bytes in dbi
Currently,
Hi,
I feel a little stupid - I suddenly remembered that I had asked about
this before and got a perfectly good answer: Use ROWID instead of a
cursor.
SELECT field, ROWID FROM table FOR UPDATE;
loop: UPDATE table SET field=? WHERE ROWID=?;
That turned out to be the simplest solution for
Hi,
I am testing DBD::Oracle on the following environment:
- Solaris 8
- Oracle 9.0.1
- perl 5.8.0
- DBI-1.30
- DBD-Oracle-1.12
Compiling DBD-Oracle fails because it uses 64-bit libs instead of 32-bit
ones (has already been discussed here). After fixing this, it compiles,
but gives the followi
What character set is the database in?
select value from v$NLS_PARAMETERS where parameter = 'NLS_CHARACTERSET'
what have you set your NLS_LANG environment variable to before your script
runs?
Are you sure the data you are getting back is wrong and not your terminal
emulator displaying it correc
Currently, I have inserted a data entry in the database (oracle) that contains an
extended character Pr\351nom to be exact. I tried use utf8 (appears to be for source
text), and
use bytes, but still whenever the data is selected from oracle using dbi, I get back
Prenom, which is not the same t
Hi,
We are finding DBI 1.12 core dumps on make test. I have added script as
an gzipped attachment. Any clues would be helpful.
make test
PERL_DL_NONLAZY=1 /opt/local/bin/perl -Iblib/arch -Iblib/lib
-I/opt/local/packages/perl-5.6.1/lib/5.6.1/sun4-solaris-thread-multi
-I/opt/local/packages
Hi all,
I have a problem with he installation of DBD-pg 1.13 on Mac. The make
works fine but when I run "make test" this is the result:
[pbraf:~/EQAS/DBD-Pg-1.13] raf% make test
PERL_DL_NONLAZY=1 /usr/bin/perl -Ibl
28 matches
Mail list logo
