Re: DBD DBI Problem

On Wed, Nov 09, 2005 at 08:34:39AM -0800, Jonathan Leffler wrote: > On 11/9/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > Hello, > > I'm having a trouble when i try to execute a simple perl program. > > > > Perl version : 5.6.1. > > OS : SunOS 5.8 > > > > The source code: > > > > #!/usr/

Re: DBD::Oracle and $sth->{PRECISION}

On Mon, Oct 17, 2005 at 05:41:20PM +0100, Tim Bunce wrote: > On Mon, Oct 17, 2005 at 08:24:17AM -0400, Eric Lenio wrote: > > On Mon, Oct 17, 2005 at 11:50:22AM +0100, Tim Bunce wrote: > > > On Sat, Oct 15, 2005 at 11:02:42PM -0400, Eric Lenio wrote: > > > > On Fri, Oc

Re: DBD::Oracle and $sth->{PRECISION}

On Fri, Oct 14, 2005 at 10:09:17PM +0100, Tim Bunce wrote: > > Here's an off-the-top-of-my-head patch, totally untested and barely > thought about, but it seems plausible... > > Index: oci8.c > === > --- oci8.c (revision 1086) >

Re: DBD::Oracle and $sth->{PRECISION}

On Fri, Oct 14, 2005 at 10:09:17PM +0100, Tim Bunce wrote: > On Thu, Oct 13, 2005 at 12:57:52PM -0400, Eric Lenio wrote: > > > > # failed test 36 at line 109. > > > > FAILED tests 12, 24, 36-38 > > > > Failed 5/35 tests, 85.71% okay > > >

Re: DBD::Oracle and $sth->{PRECISION}

On Thu, Oct 13, 2005 at 05:34:15PM +0100, Tim Bunce wrote: > On Thu, Oct 13, 2005 at 10:03:39AM -0400, Eric Lenio wrote: > > On Thu, Oct 13, 2005 at 09:32:33AM +0100, Tim Bunce wrote: > > > On Thu, Oct 13, 2005 at 01:15:21AM -0400, Eric Lenio wrote: > > > > Hi, >

Re: DBD::Oracle and $sth->{PRECISION}

On Thu, Oct 13, 2005 at 05:34:15PM +0100, Tim Bunce wrote: > On Thu, Oct 13, 2005 at 10:03:39AM -0400, Eric Lenio wrote: > > On Thu, Oct 13, 2005 at 09:32:33AM +0100, Tim Bunce wrote: > > > On Thu, Oct 13, 2005 at 01:15:21AM -0400, Eric Lenio wrote: > > > > Hi, >

Re: DBD::Oracle and $sth->{PRECISION}

On Thu, Oct 13, 2005 at 05:34:15PM +0100, Tim Bunce wrote: > On Thu, Oct 13, 2005 at 10:03:39AM -0400, Eric Lenio wrote: > > On Thu, Oct 13, 2005 at 09:32:33AM +0100, Tim Bunce wrote: > > > On Thu, Oct 13, 2005 at 01:15:21AM -0400, Eric Lenio wrote: > > > > Hi, >

Re: DBD::Oracle and $sth->{PRECISION}

On Thu, Oct 13, 2005 at 09:32:33AM +0100, Tim Bunce wrote: > On Thu, Oct 13, 2005 at 01:15:21AM -0400, Eric Lenio wrote: > > Hi, > > > > In perl 5.8.3, DBD::Oracle 1.14, DBI 1.47 I get expected values when I look > > at > > $sth->{PRECISION} to retrieve t

DBD::Oracle and $sth->{PRECISION}

Hi, In perl 5.8.3, DBD::Oracle 1.14, DBI 1.47 I get expected values when I look at $sth->{PRECISION} to retrieve the lengths of varchar2 columns for a given table. I'm now testing perl 5.8.7, DBD::Oracle 1.16, and DBI 1.48 and with the same table the values in $sth->{PRECISION} for varchar2's are

Re: set lockmode session

this should work: before setting $dbh do something like this: $ENV{ING_SET} = "SET LOCKMODE SESSION WHERE READLOCK = NOLOCK"; Refer to Ingres's System Reference Guide, Appendix A. On Tue, Jan 04, 2005 at 11:38:44AM -0500, Nina Markova wrote: > Hi, > > I'm using perl with Ingres driver. My quest

Re: DBD::Proxy

On Wed, Aug 04, 2004 at 05:57:50PM +0100, Tim Bunce wrote: > On Wed, Aug 04, 2004 at 08:02:28AM -0700, Tim Howell wrote: > > As I get started I'm interested in three things: > > > > 1. How are you using DBD::Proxy? What platform for the proxy server, > > what platform for the client, and what DB

Re: Oracle connection question

I set up dbiproxy on my Oracle server, then use DBD::Proxy to work with Oracle from several clients (including Windows). Nothing from Oracle required on the client! Email me if you're interested in a script I wrote to start/stop DBI proxying on the server. On Wed, Jun 02, 2004 at 05:24:27PM -04

DBD::Proxy - cannot do table_info

I've been trying to run table_info against a database handle that is proxied via DBD::Proxy to an oracle database and the method returns this to the client: DBD::Proxy::db table_info failed: Server returned error: Failed to execute method CallMethod: Can't call method "execute" without a package

table editing application

I have written a perl application using the DBI and Curses modules that allows you to pick a table from a given schema, and then opens it up either in a "tabular" MS Excel-like way, or in a "form" based mode. From this point you can browse, update, insert, or delete data, with the option to simple

Re: DBD-Oracle-1.14 and Oracle 9i

I have written a shell script which compiles & installs perl from source using GNU gcc on Solaris 9. This script also builds the latest DBI and DBD::Oracle, and is known to work just fine with oracle 8 & 9. The version numbers of software mentioned above are very recent (e.g., perl 5.8.2, gcc 3.3

Re: DBI primary_key tests fail: oracle 8

2004 at 10:38:45PM +, Tim Bunce wrote: > Ah, I know what that was. It's got to the point where it's > easier for me to do it than explain it so I'll look after it for you. > Just make a note to test in the next release. > > Thanks for your help! > > Tim. &g

Re: DBI primary_key tests fail: oracle 8

Hi Tim, I added your code (verbatim) immediately before the returned $dbh at the end of DBD::Oracle::connect, but got results like this for all the test scripts: t/select.Can't set DBI::db=HASH(0x1d266c)->{USER}: unrecognised attribute or invalid value at /opt/perl/.cpan/build/DBD-Oracle-1.1

Re: DBI primary_key tests fail: oracle 8

hema if $dbh->{USER} > is empty would be welcomed. > > Tim. > > p.s. Yes, $dbh->{USER} isn't part of the DBI spec and shouldn't be relied upon. > > On Fri, Jan 02, 2004 at 09:33:11AM -0500, Eric Lenio wrote: > > Hi, > > > > I have perl 5.8.2, Or

DBI primary_key tests fail: oracle 8

Hi, I have perl 5.8.2, Oracle 8.1.7, and Solaris 9. I installed DBI 1.39, then was testing DBD-Oracle 1.14 and it failed the tests in t/select.t which call DBI's primary_key routine. When I launched 'make test' with DBD-Oracle, I have set the environment var ORACLE_USERID=/, e.g., I have set up