Re: ANNOUNCE: DBI 1.42 -- DBD::Informix 2003.04 is OK with it

2004-03-18 Thread Jonathan Leffler
Tim Bunce wrote: file: $CPAN/authors/id/T/TI/TIMB/DBI-1.42.tar.gz size: 348167 bytes md5: ca8c8a1a4797d98121b41c1d0a5b3b7c =head1 CHANGES in DBI 1.42 (svn rev 222),12th March 2004 For the record, DBD::Informix 2003.04 under Perl 5.8.3 works fine with DBI 1.42 on Solaris 8 - at least a

RE: test_dynamic Error 29 installing DBD-Oracle v 1.15 on red hat 9 Oracle 9.2

2004-03-18 Thread Andy Hassall
> It would be handy to have a function that, given a $dbh, > returns 1 if the > database national char set supports unicode (which would be > true for Oracle >=9) > and 2 if the database default charset is unicode. > > Could even live in the driver as an $dbh->ora_can_unicode; method. Yes, tha

RE: can I execute DBMS packages with DBI?

2004-03-18 Thread Gold, Samuel (Contractor)
Yes you can. Here is an example. $sth_tbs_mode = $dbh->prepare("BEGIN SYS.BACKUP.BEGIN_BK(?); END;"); $sth_tbs_mode->execute($tablespace_name); Or you can use do if you are not passing any parameters. $dbh->do("BEGIN SYS.BACKUP.BEGIN_BK('USERS'); END;"); $dbh->do ("ALTER SYSTEM ..."); I

can I execute DBMS packages with DBI?

2004-03-18 Thread marc . torres
Hi all I was wondering whether or not I can run commands other than the typical SELECT, INSERT, UPDATE & DELETE. For instance, I am working with Oracle and would like to launch with Perl scripts that would use the DBMS_STATS package. And I would also like to launch commands such as: alter database

Re: test_dynamic Error 29 installing DBD-Oracle v 1.15 on red hat 9 Oracle 9.2

2004-03-18 Thread Tim Bunce
On Thu, Mar 18, 2004 at 12:36:35AM -, Andy Hassall wrote: > > I'm having some trouble installing DBD-Oracle. I get the > > following error when running make test: > > > > [snip] > > # failed test 31 at line 95. Strings differ at position 1 > > (\277 vs \23072), Len 5 > > That looks a lot

Connecting to Oracle 9i with no listener

2004-03-18 Thread John
How to get connected to an oracle server with not listener? Which one is the correct? $dbh = DBI->connect('dbi:Oracle:T:Machine:SID','username','password') $dbh = DBI->connect('dbi:Oracle:','[EMAIL PROTECTED]:Machine:SID','password') $dbh = DBI->connect('dbi:Oracle:'