RE: sth->do()

2006-06-30 Thread Loo, Peter # PHX
Hi Ron, Here is the error message, however, this external table does not exist. DBD::ODBC::db do failed: [unixODBC]ERROR: Relation 'b_sdl_123456_p_dlvrb_study_att' already exists (SQL-HY000)(DBD: Execute immediate failed err=-1) at ./try.pl line 54. nv01()=> \d b_sdl_123456_p_dlvrb_study_att D

RE: sth->do()

2006-06-30 Thread Loo, Peter # PHX
Sorry about. I meant $dbh->do(). I am trying to get the error message for Ron now. Peter Loo Wolters Kluwer Health (602) 381-9553 -Original Message- From: Garrett, Philip (MAN-Corporate) [mailto:[EMAIL PROTECTED] Sent: Friday, June 30, 2006 12:57 PM To: DBI-Users Subject: RE: sth->do

RE: sth->do()

2006-06-30 Thread Garrett, Philip \(MAN-Corporate\)
Loo, Peter # PHX wrote: > Hi All, > > I need to issue commands such as ("CREATE TABLE", "DROP TABLE", > "ALTER TABLE", etc...), however, whenever I use sth->do($sqlString), > I get an error. I understand that using sth->do(), it goes through > the process of prepare and execute. With that, it is

RE: sth->do()

2006-06-30 Thread Reidy, Ron
And the error is? -Original Message- From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] Sent: Friday, June 30, 2006 1:51 PM To: DBI-Users Subject: sth->do() Hi All, I need to issue commands such as ("CREATE TABLE", "DROP TABLE", "ALTER TABLE", etc...), however, whenever I use sth->do($sq

sth->do()

2006-06-30 Thread Loo, Peter # PHX
Hi All, I need to issue commands such as ("CREATE TABLE", "DROP TABLE", "ALTER TABLE", etc...), however, whenever I use sth->do($sqlString), I get an error. I understand that using sth->do(), it goes through the process of prepare and execute. With that, it is expecting a returned value. Can

RE: I18N in Oracle documentation

2006-06-30 Thread Garrett, Philip \(MAN-Corporate\)
cheryl fillekes wrote: > Tim, > > In the most excellent > http://search.cpan.org/dist/DBD-Oracle/Oracle.pm#Oracle_and_Unicode > there is reference to the oracle internationalization documentation. > > Do you have a more specific reference for that, particularly as > relates to 9i? A link would b

Re: memory leak in DBI XS bootstrap code

2006-06-30 Thread Tim Bunce
On Fri, Jun 30, 2006 at 04:08:46AM -0700, Ephraim Dan wrote: >This is why I love the perl community - you're willing to help even though > you don't have time, since >you care about your code, and that other people can benefit from it. > >But ... you sort of left a dangling "But" in y

RE: memory leak in DBI XS bootstrap code

2006-06-30 Thread Ephraim Dan
This is why I love the perl community - you're willing to help even though you don't have time, since you care about your code, and that other people can benefit from it. But ... you sort of left a dangling "But" in your last post. Do you have a suggestion to fix the _install_method problem?

Re: memory leak in DBI XS bootstrap code

2006-06-30 Thread Tim Bunce
On Fri, Jun 30, 2006 at 12:24:33AM -0700, Ephraim Dan wrote: > > > I don't see what you mean in the "INSTALL" that comes with perl 5.8.0 > > > (that's what we're using). > > The file called INSTALL in the perl source code directory. > > That I knew. What are the special instructions that I'm sup

make test fails for DBD::ODBC on Solaris 5.8 with openlink driver

2006-06-30 Thread Baillie, Duncan BGI UK
Hi, I have perl 5.8.0 and Solaris 5.8 with the single tier ODBC driver for connecting to SQL Server from OpenLink Software, along with their iODBC driver manager. This combination will make, but fails the tests. I don't think the t/02simple are too much to worry about but can anyone help with the

I18N in Oracle documentation

2006-06-30 Thread cheryl fillekes
Tim, In the most excellent http://search.cpan.org/dist/DBD-Oracle/Oracle.pm#Oracle_and_Unicode there is reference to the oracle internationalization documentation. Do you have a more specific reference for that, particularly as relates to 9i? A link would be great (even if it requires logging i

RE: memory leak in DBI XS bootstrap code

2006-06-30 Thread Ephraim Dan
> > I don't see what you mean in the "INSTALL" that comes with perl 5.8.0 > > (that's what we're using). > The file called INSTALL in the perl source code directory. That I knew. What are the special instructions that I'm supposed to find there? Am I supposed to build it with debugging? Can y