Hi,
I need a bit of a help with DBI/DBD combo. I have tried to narrow it
down and came up with the following.
Here is the problem summary:
Versions:
Perl: 5.6.1
DBI: 1.32
DBD-Oracle: 1.12
Operating System: Solaris 5.8
Oracle version: 8.1.7
Description:
Dan Muey wrote:
Before
SELECT KOLOM1,KOLOM8,KOLOM5,KOLOM6,KOLOM7 FROM MYTABLE
WHERE ( ( ( ( KOLOM4 = '123456' OR KOLOM4 = '' ) AND KOLOM3
= '127' )
OR KOLOM8 = 'TRUE' ) AND KOLOM1 = 'bla' )
Does this query work from the command line app?
It seems to me it wouldn't becaue you have 4 ('s and
Walter B. Takens wrote:
Dear all
i am having a problem with SQL-Statement-1.005, whereas
SQL-Statement-0.1020 is working fine.
SELECT KOLOM1,KOLOM8,KOLOM5,KOLOM6,KOLOM7 FROM MYTABLE
WHERE ( ( ( ( KOLOM4 = '123456' OR KOLOM4 = '' ) AND KOLOM3 = '127' )
OR KOLOM8 = 'TRUE' ) AND KOLOM1 = 'bla'
Hi Ed,
I had a similar problem with the Sybase module, and I went back to perl
5.6.1.
The Sybase module says it needs perl 5.6 libraries (somehow) so it fails.
Until someone compiles a 5.8 specific version (not me, don't have the
time!) you'll have to use ODBC, or use 5.6.
(This is in XP BTW)
On Fri, Feb 14, 2003 at 01:50:05PM -0500, Markham, Richard wrote:
> while (my $ary = $sth->fetchrow_arrayref) {
> print "@{$ary}\n";
> }
> Use of uninitialized value in join or string at C:\DOCUME~1\edp18\un.pl line
> 70.
> 1 DEV erpd3 8.1.7.2.0 09-FEB-03 OPEN NO 1 STOPPED ALLOWED NO AC
Thanks ronald for your assistance
~~snip~~
$dbh->{RowCacheSize} = 100;
my $sql=q{ select * from v$instance };
print "Preparing SQL\n";
my $sth = $dbh->prepare($sql);
print "Executing SQL\n";
$sth->execute;
while (my $ary = $sth->fetchrow_arrayref) {
print "@{$ary}\n";
}
$sth->finish
On Fri, Feb 14, 2003 at 01:31:00PM -0500, Markham, Richard wrote:
> perl 5.6.1
> With use warnings, dependant upon the query I execute, I will recive the
> following: Use of uninitialized value in join or string. I see this when
> I am selecting against v$ views and not when I use a table/view
Try changing all of your $ that are not variables to \$
>
>
> perl 5.6.1
> With use warnings, dependant upon the query I execute, I will
> recive the
> following: Use of uninitialized value in join or string.
> I see this when I am selecting against v$ views and not when
> I use a table/
perl 5.6.1
With use warnings, dependant upon the query I execute, I will recive the
following: Use of uninitialized value in join or string. I see this when
I am selecting against v$ views and not when I use a table/view
without a $ in the name. I'm assuming at this point that perl is parsing
>
> Dear all
>
> i am having a problem with SQL-Statement-1.005, whereas
> SQL-Statement-0.1020 is working fine.
Where dit oyu get the Label SQL-Statement-1.00XX ?
Why didn't you mark the two queries below with those?
>
> SQL ERROR: Mismatched parentheses in WHERE clause!
> SV = RV(0x810ca
With Sybase (and, probably, MSSQL) you can query the @@trancount
Transact SQL global variable. This will be 0 if there are no active
transactions.
Michael
On Fri, 2003-02-14 at 08:44, [EMAIL PROTECTED] wrote:
> In DBD::Informix, there is an attribute for $dbh for ix_InTransaction which does
>thi
Has anyone installed ActiveState Perl 5.8.0 Build 805?
I did on a test machine, and installed the DBI package with the PPM3
interface. It could not locate the DBD-DB2 package. When I added the
'repository' for DBD-DB2, PPM refused to install it for binary
incompatibility.
I've been using these mo
Roger Perttu wrote:
Hi!
When I destroy my objects I would like to know if there are
uncommitted transactions. There shouldn't be any but I would like to
know. Given only a DBI database handle, is it possible to find out if
there are uncommitted transactions? If not, is there anything inside
In DBD::Informix, there is an attribute for $dbh for ix_InTransaction which does this
for you.
It is not standardized.
---Original Message---
From: Roger Perttu <[EMAIL PROTECTED]>
When I destroy my objects I would like to know if there are uncommitted
transactions. There shouldn't be
Try an Oracle list.
There's instruction for joining one at:
http://www.cybcon.com/~jkstill/util/maillist/maillist.html
Jared
On Thursday 13 February 2003 06:36, Morrison Davis wrote:
> This is probably more of an oracle problem than DBI problem but I'm
> getting desperate. I can connect
> from
Holding cursors open is a feature.
Really. :)
Keeping cursors open for reuse can save a lot of
time. Just because you close the cursor in the your
program does not mean Oracle will close it also.
Have your DBA's session_cached_cursors. This is
the number of cursors that will be cached in the
Hi,
I still have the default max number of database connections (32), but
instead of increasing it I want the connections to be closed down
after being used. I get an increasing number of these:
postgres 22906 695 0 13:40 ? 00:00:00 postgres: apache testdb [local]
postgres 22913 695 0 13:41 ? 00:
I did not see a lot of sample script regarding perl and DB2 but if you want
tell me what kind of example you are looking for and I will sent you a
couple of script I've made. I use DB2 and Perl on a regulary basis.
Stéphane Legault, ing.
Services Mondiaux IBM
IBM Canada Ltée
Architecte, SEDQ/Tech
Does anybody know where IBM publish sample Perl code for their UDB/DB2 (dbh)
structures. I am using Solaris; Linus and AIX.
Thanks
_
Get Free Web email Account from the MetroCentre ---> http://www.metro-centre.co.uk
___
Can you post an example script that calls selectrow_hashref and
demonstrates the problem?
Tim.
On Fri, Feb 14, 2003 at 01:18:56PM +1100, Craig Sanders wrote:
> this seems to have changed since i installed DBI 1.32 (i upgraded from 1.30),
> and is breaking some scripts which assume that it will al
Mark,
The solution you suggested worked fine for my install of DBI, however I
then encountered the same error when building the DBD::DB2 module.
Unfotunately, the DBAs are not happy about putting the DB2 Application
Development Client (a pre-req to the install) on the box I used last time
to gene
this seems to have changed since i installed DBI 1.32 (i upgraded from 1.30),
and is breaking some scripts which assume that it will always return a hash.
sometimes (when the query returns no rows), it returns the scalar "1" -
attempting to use that as a hashref causes the script to die (with "str
Dear all
i am having a problem with SQL-Statement-1.005, whereas
SQL-Statement-0.1020 is working fine.
SQL ERROR: Mismatched parentheses in WHERE clause!
SV = RV(0x810cad0) at 0x829105c
REFCNT = 1
FLAGS = (PADBUSY,PADMY,ROK)
RV = 0x83844e4
DBD::CSV::st execute failed: dbih_getcom handle
'DBD
23 matches
Mail list logo