RE: DBD::Oracle and Perl 5.8.2 threads

2004-01-06 Thread Jeff Urlwin
> > On Tue, 2004-01-06 at 13:09, Tim Bunce wrote: > > On Tue, Jan 06, 2004 at 12:29:43PM -0800, Michael Peppler wrote: > > > On Tue, 2004-01-06 at 09:05, Sean Kelly wrote: > > > > Quoting Gerald Richter <[EMAIL PROTECTED]>: > > > > > > > > > Do you have any chance to test the same scripts with >

handling oracle long data types

2004-01-06 Thread praveen
hi- i have been using DBI along with DBD::JDBC for working with oracle databases. i have an issue which i hope someone can help me with. i need to select text that is stored as "long" in oracle 9i. now i want to compare that with a string that i read from a file. someone suggested that i can us

Re: DBI primary_key tests fail: oracle 8

2004-01-06 Thread Andy Hassall
Eric Lenio wrote: > OK Tim. One other note -- after reading through oracle docs, I think > you might want to substitute 'session_user' for 'current_schema' in > 'select sys_context(...)'. The definition of session_user is > "returns the database > user name by which the current user is authenticat

Re: alter session

2004-01-06 Thread Andy Hassall
Igor Korolev wrote: > Is there a way to do something like > > alter session set optimizer_mode = rule > > via DBI (Oracle database) ? $dbh->do('alter session set optimizer_mode = rule'); -- Andy Hassall ([EMAIL PROTECTED]) icq(5747695) (http://www.andyh.co.uk) Space: disk usage analysis tool (

Re: DBI primary_key tests fail: oracle 8

2004-01-06 Thread Eric Lenio
OK Tim. One other note -- after reading through oracle docs, I think you might want to substitute 'session_user' for 'current_schema' in 'select sys_context(...)'. The definition of session_user is "returns the database user name by which the current user is authenticated" while current_schema is

Re: DBD::Oracle and Perl 5.8.2 threads

2004-01-06 Thread Michael Peppler
On Tue, 2004-01-06 at 13:09, Tim Bunce wrote: > On Tue, Jan 06, 2004 at 12:29:43PM -0800, Michael Peppler wrote: > > On Tue, 2004-01-06 at 09:05, Sean Kelly wrote: > > > Quoting Gerald Richter <[EMAIL PROTECTED]>: > > > > > > > Do you have any chance to test the same scripts with Perl 5.8.0 ? > >

alter session

2004-01-06 Thread Igor Korolev
Hi, Is there a way to do something like alter session set optimizer_mode = rule via DBI (Oracle database) ? Thanks, > Igor Korolev > >

Re: DBI primary_key tests fail: oracle 8

2004-01-06 Thread Tim Bunce
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. > Tue, Jan 06, 2004 at 05:26:34PM -0500, Eric Lenio wrote: > Hi Tim, > > I added your code (

Re: DBI primary_key tests fail: oracle 8

2004-01-06 Thread Eric Lenio
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: DBD::Oracle and Perl 5.8.2 threads

2004-01-06 Thread Tim Bunce
On Tue, Jan 06, 2004 at 12:29:43PM -0800, Michael Peppler wrote: > On Tue, 2004-01-06 at 09:05, Sean Kelly wrote: > > Quoting Gerald Richter <[EMAIL PROTECTED]>: > > > > > Do you have any chance to test the same scripts with Perl 5.8.0 ? > > > > I have now built and installed Perl 5.8.0 using G

Re: DBD::Oracle and Perl 5.8.2 threads

2004-01-06 Thread Michael Peppler
On Tue, 2004-01-06 at 09:05, Sean Kelly wrote: > Quoting Gerald Richter <[EMAIL PROTECTED]>: > > > Do you have any chance to test the same scripts with Perl 5.8.0 ? > > I have now built and installed Perl 5.8.0 using GCC 2.95.3 on my Solaris > 8 for sparc box. I then installed DBI 1.39 and DB

ANNOUNCE: Alzabo 0.82

2004-01-06 Thread Dave Rolsky
0.82 January 6, 2003 ENHANCEMENTS: - The Alzabo::Runtime::Table->insert() and Alzabo::Runtime::InsertHandle->insert() will not create a new row object when called in void context. This should make inserts faster when you don't need a row object back. - When reverse engineering a MySQL schema,

Re: DBD::Oracle and Perl 5.8.2 threads

2004-01-06 Thread Sean Kelly
Quoting Gerald Richter <[EMAIL PROTECTED]>: > Do you have any chance to test the same scripts with Perl 5.8.0 ? I have now built and installed Perl 5.8.0 using GCC 2.95.3 on my Solaris 8 for sparc box. I then installed DBI 1.39 and DBD::Oracle 1.14. Oracle 9i was already installed. Code

RE: Help - multiple Oracle versions

2004-01-06 Thread Jared Still
I read quickly through this thread, so my apologies if someone already pointed this out. It doesn't matter which version of Oracle you compiled DBD with, you can connect to all your 8i/9i databases on any platform with it. Assume you compiled with 9i libs, and you can connect to 9i db's with no p

Re: DBD::Oracle and Perl 5.8.2 threads

2004-01-06 Thread Sean Kelly
Quoting Gerald Richter <[EMAIL PROTECTED]>: > Do you have any chance to test the same scripts with Perl 5.8.0 ? I will need to build 5.8.0. I shall try to get this done. > Can you provide we a stack backtrace from the segfault? No gdb on the box so I guess I'll build that as well :) > >

Re: DBD::Oracle and Perl 5.8.2 threads

2004-01-06 Thread Gerald Richter
Hi, I have written the thread support for a customer of us. I wrote and tested it for Perl 5.8.0. I guess some of the internals of the Thread Handling in 5.8.2 have changed and makes things incompatible. Do you have any chance to test the same scripts with Perl 5.8.0 ? Can you provide we a stack