Re: Slightly Off-topic: Monitoring Oracle Remotely

We here at Pythian use DBI and DBD::Oracle, DBD::MySQL, DBD::OLE and DBD::ODBC to do all sorts of helth and other checkes. So it can and is being done. I do not do that side of the bizness so I am not sure how much I can give away withoutbeing sacked. Cheers John Scoles > This may be slightly of

Re: Ways of ensuring integers in the database are seen as numbers in perl?

Tim Bunce wrote: On Wed, Jan 28, 2009 at 10:30:49AM -0500, John Scoles wrote: I think this is on purpose. Oracle numbers have a huge precision (38 decimal digits), so in general you cannot convert them to a perl number without losing precision. DBD::Oracle could be sma

Slightly Off-topic: Monitoring Oracle Remotely

This may be slightly off-topic, but it involves DBD::Oracle. Is anyone checking the health of an Oracle instance remotely? Perhaps in a way that just gives a return code for Zenoss*, that is. We're currently trying to implement a health check using

Re: Ways of ensuring integers in the database are seen as numbers in perl?

On Wed, Jan 28, 2009 at 10:30:49AM -0500, John Scoles wrote: > >> >> > >> >> I think this is on purpose. Oracle numbers have a huge precision (38 > >> >> decimal digits), so in general you cannot convert them to a perl > >> number > >> >> without losing precision. DBD::Oracle could be smart enough

Re: DBD::Oracle - problem migrating from 9i to 11g

Both would be great. I am at home today as well with 50kph winds, -24c and 25cm snow-storm in progress Seems the 11.1.0.7 for sun has a number of issues. It would be neat to see if you run into another issues as well I have a test you could try and run it you have time. I have attached it all

Re: DBD::Oracle - problem migrating from 9i to 11g

Thanks for the quick response John. We are running 11.1.0.7. As far as I am aware it is up to date patch-wise. I'm at home at the moment and won't be in the office for about 3 hours (UTC+11). I'll run the make test then. Do you want me to run it before the patch, after, or both? Cheers, Stev

Re: Ways of ensuring integers in the database are seen as numbers in perl?

> On Wed, Jan 28, 2009 at 06:32:19AM -0500, John Scoles wrote: >> > On Tue, Jan 27, 2009 at 08:51:10PM +0100, Peter J. Holzer wrote: >> >> On 2009-01-27 15:21:55 +, Martin Evans wrote: >> >> > I'm working with DBD::Oracle at the moment and getting a little >> >> frustrated with >> >> > integer

Re: DBD::Oracle - problem migrating from 9i to 11g

Oh yeah a few more quick questions 1) Which version of 11g are you running? 2) Has it been Patched? 3) can you to a make test and send me the results Just need the above to have the proper talks with my Oracle chum cheers John Scoles > Hi, > > We have found some of our code that worked perfectl

Re: DBD::Oracle - problem migrating from 9i to 11g

Thanks for this As we are moving to 11 we are running into a number of bugs or at least changes in the way Oracle 11 is working. I have sorted through the code and determind that with the SQL you give this call to OCI OCIAttrGet_parmdp(imp_sth, fbh->parmdp, &fbh->dbsize, 0, OCI_ATTR_DATA_SIZE,

Re: Ways of ensuring integers in the database are seen as numbers in perl?

On Wed, Jan 28, 2009 at 06:32:19AM -0500, John Scoles wrote: > > On Tue, Jan 27, 2009 at 08:51:10PM +0100, Peter J. Holzer wrote: > >> On 2009-01-27 15:21:55 +, Martin Evans wrote: > >> > I'm working with DBD::Oracle at the moment and getting a little > >> frustrated with > >> > integer numbers

Re: Ways of ensuring integers in the database are seen as numbers in perl?

> On Tue, Jan 27, 2009 at 08:51:10PM +0100, Peter J. Holzer wrote: >> On 2009-01-27 15:21:55 +, Martin Evans wrote: >> > I'm working with DBD::Oracle at the moment and getting a little >> frustrated with >> > integer numbers. I'd like my database returned integers to look like >> integers >> >

Re: Ways of ensuring integers in the database are seen as numbers in perl?

On Tue, Jan 27, 2009 at 08:51:10PM +0100, Peter J. Holzer wrote: > On 2009-01-27 15:21:55 +, Martin Evans wrote: > > I'm working with DBD::Oracle at the moment and getting a little frustrated > > with > > integer numbers. I'd like my database returned integers to look like > > integers > >

Re: Ways of ensuring integers in the database are seen as numbers in perl?

Peter J. Holzer wrote: On 2009-01-27 15:21:55 +, Martin Evans wrote: I'm working with DBD::Oracle at the moment and getting a little frustrated with integer numbers. I'd like my database returned integers to look like integers to Perl but they currently don't until I add 0 to them. Here is

Re: ODBC - SQL Server image data problems with recent releases of ODBC

horace.redelm...@gmail.com wrote: I have a Perl program that writes binary data to a SQL Server image field (column of type image) using DBD::ODBC. This works fine in Perl 5.8.8 (ActivePerl build 822) ($DBD::ODBC::VERSION = '1.13';) I am using Windows XP and SQL Server 2005 and using the "SQL Se

Re: Ways of ensuring integers in the database are seen as numbers in perl?

Stephen Carville wrote: On Tuesday 27 January 2009 08:55, Martin Evans wrote: Stephen Carville wrote: On Tuesday 27 January 2009 07:21, Martin Evans wrote: Does anyone know of a way to get numbers (as I've described) back from DBD::Oracle. If you know the data is integer try: while($s->fet