The issue was the libclntsh that Oracle was loading conflicted with
SQLAnywhere , updating Oracle libs and recompiling DBD::Oracle fixes it.
On Mar 7, 2017 2:10 PM, "Douglas Wilson" <douglasg.wil...@gmail.com> wrote:
> That does work, but I can't consider it a
AM, "Martin J. Evans" <boh...@ntlworld.com> wrote:
> On 06-Mar-17 5:38 PM, Douglas Wilson wrote:
>
>> After some searching, I tried using the ora_connect_with_default_signals
>> with INT and CHLD, and tried setting BEQUEATH_DETACH=yes in a local
>> sq
After some searching, I tried using the ora_connect_with_default_signals
with INT and CHLD, and tried setting BEQUEATH_DETACH=yes in a local
sqlnet.ora, but still same result.
On Mar 4, 2017 5:17 AM, "Martin J. Evans" <boh...@ntlworld.com> wrote:
> On 02-Mar-17 10:54 PM, D
DBD::SQLAnywhere seems to work ok for Sybase IQ, but if I first create a
DBD:Oracle handle, the SQLAnywhere connect hangs for a while, and
eventually segfaults. FYI on redhat Linux.
On Feb 17, 9:59 am, b...@wards.net (Bill Ward) wrote:
You can be reasonably safe using inline params like that if you're careful
to make sure $q contains only the sort of characters that make sense for
your app, and/or if $q is quoted properly. You can use a regex to test that
it is only
On Feb 13, 4:46 pm, punk.k...@gmail.com (Puneet Kishor) wrote:
I asked this on Stackoverflow and on Perlmonks, but hopefully I will get a
more satisfactory and revealing insight straight from the DBI folks.
I don't know why you need to ask this in three different forums. As
you've been told
to see how to make it work for both
unicode and non-unicode data.
Michael
On Tue, Aug 9, 2011 at 2:58 AM, Douglas Wilson
lt;douglasg.wil...@gmail.comgt; wrote:
gt; I'm using perl 5.8.8 with DBD::Sybase 1.09, and the SQL statement
gt; below appears to prepare and execute fine
I'm using perl 5.8.8 with DBD::Sybase 1.09, and the SQL statement
below appears to prepare and execute fine, but I've also just compiled
a perl 5.14.1 with DBD::Sybase 1.12, and with the newer versions I get
the following error on prepare:
DBD::Sybase::db prepare failed: Server message
Seeing as how all the necessary index information is in the system
tables, it shouldn't be all that hard to write a statistics_info
method...I'm sure patches would be gladly accepted :-)
-Doug
On Thu, Dec 17, 2009 at 5:49 AM, White, Richard L rlwh...@illinois.edu wrote:
Martin,
Thanks for
2009/5/7 Yannis Haralambous yannis.haralamb...@telecom-bretagne.eu:
Hi,
I'm trying to install DBD::Oracle 1.23 under MacOS X 10.5 with ActiveState
Perl 5.8. I'm getting the following error message:
FYI, DBD::Oracle comes with ActiveState perl v 5.10.
-Doug
or not, but there is
a NUM_OF_PARAMS statement handle attribute that'll tell you how many
placeholders are in the statement.
HTH,
Douglas Wilson
Where did you get the ppd from?
I don't see any PPMs listed here:
http://cpan.uwinnipeg.ca/search?query=dbd-sybasemode=dist
I do have DBD::Sybase working with 5.10 on Unix, so it does
work. On Windows I can't compile it due to no client library, so
I use ODBC.
On Thu, Mar 26, 2009 at 10:40 AM,
I should have saidI have DBD-Sybase 1.08 working with perl 5.10
On Fri, Mar 27, 2009 at 8:56 AM, Douglas Wilson
douglasg.wil...@gmail.com wrote:
Where did you get the ppd from?
I don't see any PPMs listed here:
http://cpan.uwinnipeg.ca/search?query=dbd-sybasemode=dist
I do have DBD::Sybase
/~runrig/journal/35908
HTH,
Douglas Wilson
.
-Douglas Wilson
On Thu, Feb 5, 2009 at 1:23 AM, Peter J. Holzer h...@wsr.ac.at wrote:
On 2009-02-03 10:06:48 -0800, Douglas Wilson wrote:
On Tue, Feb 3, 2009 at 5:47 AM, Deviloper devilo...@slived.net wrote:
I think this could be understood differently than you probably meant it.
Perl variables
On Tue, Feb 3, 2009 at 5:47 AM, Deviloper devilo...@slived.net wrote:
But some bad guy could showed up and force the poor developer not to use
perl-vars in SQL-Statements for security reasons.
Is ist possible to use tablenames like normal bind-variables?
Is there a better way to solve this
that you wouldn't have to have a recursive function, and
all the work would be in the database instead of perl, and in an
effort to see if DB2 had anything similar, I found this:
http://bytes.com/groups/ibm-db2/183346-how-convert-oracle-sql-connect-db2-sql
HTH,
Douglas Wilson
On Mon, Dec 29, 2008 at 11:00 AM, William Gordon Rutherdale
will.rutherd...@utoronto.ca wrote:
DBI 1.607. However the DBD::Pg ppm is not available at ActiveState, so I
Get it from the trouchelle repo. See:
http://cpan.uwinnipeg.ca/dist/DBD-Pg
HTH,
Douglas Wilson
On Tue, Dec 2, 2008 at 4:27 AM, Larry W. Virden [EMAIL PROTECTED] wrote:
With the DBI RaiseError condition set, all DBI related statements are
going to raise an exception, so none of the or die statements are
necessary ... they won't hurt (or help), but their presence may
deceive the novice
, but it looks like a bug.
Also, since RaiseError is set, the or die... part of this will never get
executed either:
$getMatchRec-execute()
or die Couldn't fetch records from CSI_CORE;
So I'd call that a bug of sorts also.
-Douglas Wilson
On Mon, Dec 1, 2008 at 7:58 AM, Larry W. Virden [EMAIL PROTECTED] wrote:
Now, when the PERSON_ID matches, the update occurs. When the
PERSON_ID is not found, however, an error isn't raised.
updating zero rows is not an error.
you can detect it yourself with:
my $rows = $sth-execute();
Then
On Wed, Oct 22, 2008 at 9:12 AM, Martin Evans [EMAIL PROTECTED] wrote:
John Scoles wrote:
Well what you might want to do is convert the out data like this
SELECT SYSTIMESTAMP,to_char(SYSTIMESTAMP,'mm--dd:hh:s') FROM dual
I usually just add this after every connect():
I know dealing with float columns are fraught with rounding errors, but I'm
just wondering about the best way to deal with them.
I'm using DBD::Sybase, and some of our floats have the smallest
possible value... -1.7976931348623157e+308
When I just do:
select float_column from my_table
into a
On Tue, Oct 7, 2008 at 9:32 AM, Mr. Shawn H. Corey [EMAIL PROTECTED] wrote:
On Tue, 2008-10-07 at 09:02 -0700, Douglas Wilson wrote:
BTW, don't use SELECT *. If your DBA rebuilds the tables with a
different column order, your code will fail. Specifically name the
columns (or if you really
On Wed, Sep 10, 2008 at 9:53 AM, Bruce Johnson
[EMAIL PROTECTED] wrote:
On Sep 10, 2008, at 4:14 AM, John Scoles wrote:
Well that is a head scratcher. It will be hard to replicate this error so
look like you will have to do the debugging for us.
If you can set up a small Perl script that
On Fri, Sep 5, 2008 at 8:42 AM, Bruce Johnson
[EMAIL PROTECTED] wrote:
Where can I find older versions of DBD::Oracle...in particular I need 1.18
or 1.17
Even versions deleted from CPAN should still be on http://backpan.cpan.org
On Wed, Aug 27, 2008 at 11:41 AM, Bruce Johnson
[EMAIL PROTECTED] wrote:
Is anything 'baked-in' from the oracle environment to a DBD:Oracle install
at the time of installation?
I'm having some weird problems involving linked databases that MAY be
related to the oracle client libraries
On Tue, Aug 5, 2008 at 11:38 PM, olwin [EMAIL PROTECTED] wrote:
Upper limit, in bytes, the amount of buffered information. Setting
buffer_size to NULL specifies that there should be no limit.
Is there a way to specified a null size ?
P.S : I use:
DBD::Oracle : 1.15
DBI : 1.42
Try
,
Douglas Wilson
On Mon, Jul 14, 2008 at 8:48 PM, Dondi Stroma [EMAIL PROTECTED] wrote:
Is it possible to retrieve the associated parent db handle from a statement
handle? I am subclassing DBI and am overriding a few statement methods, and
in those statement methods I would like to store information in the db
message (That's all I can refer to at the
momentThere should be some standard among DBD's).
TIA,
Douglas Wilson
On Thu, Jun 19, 2008 at 1:53 PM, Tim Bunce [EMAIL PROTECTED] wrote:
On Wed, Jun 18, 2008 at 02:14:06PM -0700, Douglas Wilson wrote:
With RaiseError or PrintError set, if DBD::Sybase throws an error, the
error message does not indicate what line number of the program that the
error
On Tue, Apr 15, 2008 at 2:30 PM, Tim Bunce [EMAIL PROTECTED] wrote:
Try this (completely untested) patch to the DBI:
--- Driver.xst (revision 10993)
+++ Driver.xst (working copy)
@@ -157,7 +157,11 @@
AV *row_av;
PPCODE:
if (SvROK(ST(1))) {
- sth = ST(1);
+
On Tue, Apr 15, 2008 at 2:30 PM, Tim Bunce [EMAIL PROTECTED] wrote:
Try this (completely untested) patch to the DBI:
like I said...it works for me, but if that's the fix, then
you'll want to do selectall_arrayref also (same problem).
-Doug
On Mon, Apr 14, 2008 at 3:28 AM, Tim Bunce [EMAIL PROTECTED] wrote:
Did you build a fresh copy of DBD::Sybase after upgrading DBI?
To get this fix you'd need to do that.
Probably worth retrying, just to be sure.
I didn't really upgrade DBI, as
it is a brand new install of perl (5.10.0),
On Thu, Apr 10, 2008 at 3:36 PM, Tim Bunce [EMAIL PROTECTED] wrote:
On Thu, Apr 10, 2008 at 11:15:30AM -0700, Douglas Wilson wrote:
Are you *certain* that that code is running with DBI 1.602?
Try adding a print of $DBI::VERSION.
Yes, I am certain. This is a new install (and I checked
With DBI 1.602 and DBD::Sybase 1.08 I get:
Can't locate object method DELETE via package DBI::st
on the second selectrow_array call.
If I replace $sth with $sql in the selectrow_array calls, then it
works correctly.
I did find a similar problem here:
:54 AM, Tim Bunce [EMAIL PROTECTED] wrote:
On Wed, Apr 09, 2008 at 04:29:48PM -0700, Douglas Wilson wrote:
with trace(9)
$dbh-trace(9);
my $total;
( $total ) = $dbh-selectrow_array( $sth, undef, $id );
( $total ) = $dbh-selectrow_array( $sth, undef, $id );
A DBI trace should shed more
- Original Message -
From: Sterin, Ilya [EMAIL PROTECTED]
The list will now receive email about any FAQ changes.
I think once a week or month would be plenty...
-Douglas Wilson
, and_maybe_another
fetch some_cursor into some_variable, and_maybe_another_variable
close some_cursor
then again, maybe you could rename it 'im_all_done_fetching()' :-)
-Douglas Wilson
to be compiled, and installs just fine the normal way,
i.e.,perl Makefile.PL/make/make test/make install, but s/make/nmake/, and
first get nmake.exe from MSDN.
HTH,
Douglas Wilson
,
Douglas Wilson
in Informix ( other databases?)
are actually all spaces. You cannot store an actual 'empty string' unless
you use a VARCHAR field.
HTH,
Douglas Wilson
that loops over @_ instead of something hard coded.
Hope someone thinks of something better...
HTH,
Douglas Wilson
From: Cliff Nadler [EMAIL PROTECTED]
my @login=split(/:/,chomp($line));
This does not do what you think it does.
'chomp' returns the number of characters removed.
Check the docs.
HTH,
Douglas Wilson
that
fetched some, but not all, rows. In benchmarking, the saved call
to finish() did not quite make up for the extra logic to determine
if some but not all rows were fetched (but the difference was
negligible). It just seemed more 'correct'
that way, but I was wondering if it was necessary.
-Douglas Wilson
$sql_stmt = q/select * from v$tables/;
or a single quoted here doc:
my $sql = 'EOT';
select * from v$tables
EOT
HTH
-
Douglas Wilson
Perl Hacker for Hire (Inquire Within)
you call 'commit'.
HTH
-
Douglas Wilson
Perl Hacker for Hire (Inquire Within)
is supposed to return the number of rows affected in a
non-select
statement. If 0 rows are returned, the value is still true, so you must
explicitly
compare it to zero, e.g.:
my $rows = $sth-execute;
if ($rows == 0) { # NOT 'if ($rows)...'
# do stuff
}
HTH,
Douglas Wilson
-Doug
From: Morrison Davis [EMAIL PROTECTED]
The only problem is it counts carriage returns as 1 character
where as perl length() counts them as 2. And DBI automatically
considers anything over 4000 as a LONG.
Perhaps a newline (\n) is getting converted to carriage return/newline
(\r\n)
it is a part of
selectall_arrayref, which
can return an AoH or AoA, depending on the arguments. See the docs.
HTH,
Douglas Wilson
Programmer/Troubleshooter for Hire
Southern California
52 matches
Mail list logo
