Thanks James.
Tim.
On Tue, Apr 19, 2005 at 04:31:39PM -0500, James D. White wrote:
I had a slight problem while installing DBD::Oracle 1.16 on a 64-bit Perl
5.8.5 running
on a Solaris 9 system with Oracle 9i. perl Makefile.PL tried to use the
32-bit Oracle
libraries. The Oracle 9 (and 8
From: Ian Harisay [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 19, 2005 12:43 PM
snip
My perl program appears to be stripping trailing spaces. I
dynamically build my sql statement with the following function.
I am using
Linux Fedora Core 3
perl 5.8.5
DBD::Oracle 1.16
DBI 1.40
Hi,
I've been using PERL and especially the DBI module for Oracle and now
recently MySQL. I'm having trouble with getting DBD::MySQL in compiled form to
work from Windows/XP. I really (being honest here) resent having to install the
binary form of PERL from Active State yet I've tried and
Not sure about perl 5.6, but I've been using DBI, DBD::MySQL and MySQL for some
months on Windows 2000 with ActivePerl 5.8.4. Not exactly the same but
hopefully that at least shows the DBI/MySQL/Windows combination can work.
HTH,
WH
- Original Message -
From: Roy Niemann [EMAIL
Hi. I'm working on a project using DBD::Oracle 1.16, DBI 1.43, Perl 5.6,
WinXP, and Oracle 8.1.7.4.
My script runs through a loop many times, and each time through it calls
two PL/SQL stored procs via a wrapper class I've built. At some point in
the loop I run out of ref cursors; Oracle returns a
Michael et. al,
That is not how ref cursors work. When the Perl variable goes out of scope,
the cursor is not closed. See
http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:553222846752
In my testing, I can confirm the cursors stay in existence until the connect
handle is
Ron,
Thanks a lot for the reply. I appreciate your taking the time to look
into this.
On Wed, 20 Apr 2005 12:47:01 -0600, Reidy, Ron
[EMAIL PROTECTED] said:
Michael et. al,
That is not how ref cursors work. When the Perl variable goes out of
scope, the cursor is not closed. See
My comments in line ...
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
snip
On Wed, 20 Apr 2005 12:47:01 -0600, Reidy, Ron
[EMAIL PROTECTED] said:
Michael et. al,
That is not how ref cursors work. When the Perl variable goes out of
scope, the cursor is not closed. See
From: Reidy, Ron [EMAIL PROTECTED]
Date: 2005/04/20 Wed PM 01:47:01 CDT
In my testing, I can confirm the cursors stay in existence until the connect
handle is disconnected/destroyed.
So, couldn't the script build the $dbh, pass it to the loop, have the
loop clone() the $dbh, run the
From: amonotod [EMAIL PROTECTED]
Date: 2005/04/20 Wed PM 02:35:37 CDT
Also, since the OP mentioned running the loop 1500(0?) times
Boy, I don't know where I got that... He just said many times
Doh!
amonotod
--
`\|||/ amonotod@| sun|perl|windows
(@@)
Ron,
Thanks for the reply, again.
On Wed, 20 Apr 2005 13:22:48 -0600, Reidy, Ron said:
My comments in line ...
snip
On Wed, 20 Apr 2005 12:47:01 -0600, Reidy, Ron said:
Michael et. al,
That is not how ref cursors work. When the Perl variable goes out of
scope, the cursor is not
On Wed, 20 Apr 2005 14:41:33 -0500, amonotod said:
From: amonotod
Date: 2005/04/20 Wed PM 02:35:37 CDT
Also, since the OP mentioned running the loop 1500(0?) times
Boy, I don't know where I got that... He just said many times
No, you were right -- I said 1500 in my first reply.
Comments below ...
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
snip
OK, but in the thread you posted from asktom.oracle.com, the response to
the poster was:
v$open_cursor can be misleading -- it is cursors that have been opened
at some
point and may (or may not be) still open.
On Wed, 20 Apr 2005 14:35:37 -0500, amonotod said:
Also, since the OP mentioned running the loop 1500(0?) times, the
database shouldn't be in production mode,
What do mean here?
Mike
On Wed, 20 Apr 2005 13:53:03 -0600, Reidy, Ron said:
[rr] I was testing on a DB instance where I was the only user at that
time. I did not bother to check v$sesstats (I probably should have),
but I will leave this to your testing.
OK. I'm not sure what the difference is, but in any case it
On Wed, Apr 20, 2005 at 03:46:20PM -0400, Michael Styer wrote:
What about this:
http://search.cpan.org/~timb/DBD-Oracle-1.16/Oracle.pm#Binding_Cursors
At the end of the Binding Cursors section it says that cursors need to
be (and can be) closed with code like this:
$sth3 =
Ron,
I'm Sorry for not getting the name right.
I tried to reinstall the Oracle client. I am getting errors like the
following:
Error in invoking target relink of makefile ins_precomp.mk, and a whole
bunch of other mk relink errors. I kept ignoring them. And finally the
installer reported the
On Wed, 20 Apr 2005 13:46:13 -0700, Tim [EMAIL PROTECTED] said:
On Wed, Apr 20, 2005 at 03:46:20PM -0400, Michael Styer wrote:
Is anyone able to shed some light on the situation?
The t/50cursor.t test script in the DBD::Oracle distribution uses that
code to close the cursors that it has
On Wed, 20 Apr 2005 13:46:13 -0700, Tim [EMAIL PROTECTED] said:
The t/50cursor.t test script in the DBD::Oracle distribution uses that
code to close the cursors that it has opened.
OK, I tried using that code to test my local installation. I had trouble
running the tests per se via the CPAN
Hi Folks
http://savage.net.au/Perl/html/upgrade-perl-apache.html
via
http://savage.net.au/Perl.html
--
Ron Savage
[EMAIL PROTECTED]
http://savage.net.au/index.html
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* is it possible to access the PostgreSQL engine from a perl source?
* without compile in windows ?
* whats the better method to access postgreSql data ?
You normally need to compile, but someone is working on a ppd for
DBD::Pg on Windows. You
21 matches
Mail list logo