Re: DBD::Pg - send arrays to a stored procedure

2005-01-17 Thread Rudy Lippan
On Mon, 17 Jan 2005, Dmitry Karasik wrote: > Hello, Hello, > > After I've upgraded to newest versions of DBI(1.46) and DBD::Pg (1.32), my > scripts started to fail while feeding arrays into stored procedures in > postgresql base (v7.4.6). The (old working) code was something like > > $dbh

ANN: Gtk2::Ex::DBI-0.6

2005-01-17 Thread Dan
I'm pleased to annouce the 6th release of Gtk2::Ex::DBI ... http://entropy.homelinux.org/Gtk2-Ex-DBI/ Gtk2::Ex::DBI is an open-source helper object that makes your Gtk2-Perl apps data aware. It handles querying, 'painting' records on your Glade-generated form, passing updates back to the database

Re: DBD Oracle DBI driver

2005-01-17 Thread Michael A Chase tech
On 01/17/2005 12:04 PM, Moreno, Javier said: Does anyone know of a repository where I can find DBD::Oracle? I have tried the ActiveState default repository but it reports it is not available. It would be worthwhile for you to read the responses sent to you before you ask the same question again. --

RE: How to call Oracle DBs via DBI ODBC

2005-01-17 Thread Reidy, Ron
Javier, Did you not like my response from Jan 16? Again: This is not a Perl/ODBC issue. This is a problem with Oracle. From the oerr utility: 12514, 0, "TNS:listener could not resolve SERVICE_NAME given in connect descriptor" // *Cause: The SERVICE_NAME in the CONNECT_DATA was not foun

How to call Oracle DBs via DBI ODBC

2005-01-17 Thread Moreno, Javier
All, I have a web application which calls an Oracle database. I was unable to connect to it but I found out it was because the HTTP port the TNS was listening to was not the same one the webserver was running on. I have fixed that on the webserver end. However, it seems the call to the TNS is g

Re: DBD Oracle DBI driver

2005-01-17 Thread amonotod
> From: "Moreno, Javier" <[EMAIL PROTECTED]> > Date: 2005/01/17 Mon AM 11:04:56 CST > > All, > > Does anyone know of a repository where I can find DBD::Oracle? I have tried > the ActiveState default repository but it reports it is not available. You found the list, did you not find the archives

DBD Oracle DBI driver

2005-01-17 Thread Moreno, Javier
All, Does anyone know of a repository where I can find DBD::Oracle? I have tried the ActiveState default repository but it reports it is not available. Regards, Javier Moreno

Re: SV: Survey: Do you use positioned updates from DBI ?

2005-01-17 Thread Jonathan Leffler
On Mon, 17 Jan 2005 07:54:42 +0100, Henrik Tougaard <[EMAIL PROTECTED]> wrote: > > I'm hoping to get some feedback on how often updatable > > cursors are being used in DBI apps ? > We use it from timne to time. I have implemented them in DBD::Ingres (see > ing_readonly in the DBD::Ingres docs). >

DBD::Sybase $dbh->clone errors...

2005-01-17 Thread amonotod
Hello all, Now, I'm not sure this is an error, since it does succeed, but the attached script will produce a warning about an unknown attribute. What I'm doing is connecting to a Sybase server, cloning the connection, running a query, and then running another query based off of the first one.

DBD::Pg - send arrays to a stored procedure

2005-01-17 Thread Dmitry Karasik
Hello, After I've upgraded to newest versions of DBI(1.46) and DBD::Pg (1.32), my scripts started to fail while feeding arrays into stored procedures in postgresql base (v7.4.6). The (old working) code was something like $dbh-> selectrow_array("SELECT dummy(?)", {}, [ 1, 2, 3]); where 'dumm

Re: DBD::Oracle

2005-01-17 Thread Michael A Chase tech
On 01/17/2005 05:02 AM, Waghmare, Satish (IE03x) said: Send me the PPM package for DBD::Oracle.Activestate 5.8 http://ftp.esoftmatic.com/DBI/ -- Mac :}) ** I usually forward private questions to the appropriate mail list. ** Ask Smarter: http://www.catb.org/~esr/faqs/smart-questions.html Give a

Re: Patch for DBD::SQLite - spurious undef warning

2005-01-17 Thread Tim Bunce
The DBI provides a neatsvpv(sv, maxlen) function specifically for use in trace messages etc (it's the same as DBI::neat). It handles undefs and much else besides. I'd recommend it. Tim. p.s. I'd also recommend turning of wrapping in your mail tool, or setting the wrap marging higher. On Mon, Ja

DBD::Oracle

2005-01-17 Thread Waghmare, Satish (IE03x)
Hi: Send me the PPM package for DBD::Oracle.Activestate 5.8 Best Regards, Satish Waghmare

SV: Survey: Do you use positioned updates from DBI ?

2005-01-17 Thread Henrik Tougaard
> I'm hoping to get some feedback on how often updatable > cursors are being used in DBI apps ? We use it from timne to time. I have implemented them in DBD::Ingres (see ing_readonly in the DBD::Ingres docs). > My understanding is that "standard" embedded SQL uses a syntax like > DECLARE CURSOR c