Re: Informix 4 DBD Install Error

Jim Hutchins wrote: > I'm trying to use a really old version of Informix > with DBD-Informix4-0.23 on SCO OS 5. Getting a compile > time error of: > > "./dbdimp.h", line 13: error: cannot find include file: > "./dbdimp.h", line 14: error: cannot find include file: > "./dbdimp.h", line 15: error

RE: retrieving exit value from SQL function in Perl

Thanks Tim, that worked!! my $insert_cr= $dbh->prepare("DECLARE result_cr VARCHAR2(30); BEGIN ? := SYSTEM.LoadCreditReport(?,?,?); END;"); #crr_id, directory, filename ## $insert_cr->bind_param_inout(1, $return_

RE: :Oracle ping terminates script

You disconnected after the first ping, so the second ping failed as the output showed. The second version just handled this condition, and went on to excute the next statement, ie 'Finished work' not 'OK2' -Original Message- From: Andrei A. Voropaev [mailto:[EMAIL PROTECTED]] Sent: Wedne

RE: Basic Table Read Problems

That concurs with the behavior I'm seeing. Thanks --Chuck > This is only strange if you did not create the tables in the same > sqlplus session (transaction). If you created the tables in sqlplus > and then queried them, all will appear normal because both events > occurred in the same transac

Re: Basic Table Read Problems

On Wed, Nov 21, 2001 at 01:22:27PM -0600, Tomasi, Chuck wrote: > Nevermind. I believe found the problem... When I put the values in to the > table, I never committed them. Once I added two or three more small test > cases, my original table started working. Strange how SQLPlus could access > t

RE: Basic Table Read Problems

Nevermind. I believe found the problem... When I put the values in to the table, I never committed them. Once I added two or three more small test cases, my original table started working. Strange how SQLPlus could access the non-committed data, but Perl DBI could not. Yes, I already checked,

Basic Table Read Problems

OS: Solaris 7 Perl: 5.6.0 DBI: 1.20 DBD::Oracle: 1.12 I've got a bit of a puzzle. I'm making five repeated calls to a sub I called "Get Simple Table". It takes tables with a number and varchar2 field and populates two array references so I can do lookups by id or by description within the progr

Re: DBD::Sybase err handler

Tami King writes: > Does someone have an error handler for dealing with dbcc messages that > they would be willing to share with me. My server isn't heavily used > and I haven't even been able to catch a "spurious allocation error", so > I don't know if what I have will work or not. Have yo

Informix 4 DBD Install Error

I'm trying to use a really old version of Informix with DBD-Informix4-0.23 on SCO OS 5. Getting a compile time error of: "./dbdimp.h", line 13: error: cannot find include file: "./dbdimp.h", line 14: error: cannot find include file: "./dbdimp.h", line 15: error: cannot find include file: My v

Re: Extraction of a LONG field from Perl

Can someone tell me what is wrong with this: I am trying to execute through perl a stored oracle procedure that make a select on a table that hold a LONG field. 1- perl program: use DBI; $pathOut = '/home/psoft/interface/out'; $pathDone = '/home/psoft/interface/done'; $serveur= 'toto'; $sender= '

RE: Inserting data file into table

> > I slurped a data file into an array and I know there are > many ways of > > inserting the fields into a table. I was just wondering > what the most > > efficient way would be. > > Here are the relevent code snippets. > > -- > > my $id, $fname, $lname, $phone, $deptid, @table; > > my $file =

RE: retrieving exit value from SQL function in Perl

Becka, You can use "bind_param_inout", but I think it only works against an Oracle stored procedure. Here's an example of how it works: my $csr_hyphenIsbn = $dbh->prepare ("BEGIN bkpower.hyphenisbn_proc(?,?,?); END;"); $csr_hyphenIsbn->bind_param(2, $isbn); $csr_hyphenIsbn->bind_param_inout(1,

DBD::Sybase err handler

Does someone have an error handler for dealing with dbcc messages that they would be willing to share with me. My server isn't heavily used and I haven't even been able to catch a "spurious allocation error", so I don't know if what I have will work or not. This is what I have. It is mostly co

Re: Extraction of a LONG field from Perl

sami Ghorbal wrote: > is there an issue with the extraction of a LONG field with Perl? Do you mean BLOB's? If so see perldoc DBI LongReadLen, LongTruncOk and "Handling BLOB / LONG / Memo Fields". -- Simon Oliver

Problem retrieving french CLOBs with DBD::Oracle

Hello all, I am having trouble selecting CLOBs from an Oracle 8i database. The problem arises only when I am trying to select a CLOB containing an "é" or other such non-english character. Does anyone have any idea how I may be able to get over this problem?? I am using DBD-Oracle-1.08. Here is

DBD::Oracle ping terminates script

Hi! I have hit very weird problem with method 'ping' of DBD::Oracle. Here's small script that illustrates it. --- #!/usr/bin/perl use DBI; my $dbh= DBI->connect('dbi:Oracle:mydb', 'myuser', 'mypass', {RaiseError => 1, PrintError => 1, AutoCommit => 0}); die unless $dbh;

Extraction of a LONG field from Perl

Hi all, is there an issue with the extraction of a LONG field with Perl? Sami.

Re: retrieving exit value from SQL function in Perl

On 20 Nov 2001 22:10:45 -, in perl.dbi.users you wrote: > Does anyone know how to get an exit value from the following? If I have: > > $insert_cr= $dbh->prepare("DECLARE result_cr VARCHAR2(30); > > BEGIN r