Re: SQL Parser...

2004-02-05 Thread Jeff Zucker
Hi, Addi Jamshidi wrote: I am looking for a way to parse a given SQL statement and as output to received the parsed tree so I can in turn present that as XML. Basically given a SQL statement I would like to parse it and get its parsed tree in terms of XML. Others have asked about this. I'm cc

Re: Migrating from ? to Oracle

2004-02-05 Thread christopher
Hi Wiliam, You will regret it if you take that path. See if you can't (A) use one of the free development ones:- http://otn.oracle.com/software/products/oracle9i/index.html or (B) get your test machine to connect to the real Oracle (using a test schema or database maybe). Your main problems will

Re: can you help

2004-02-05 Thread Jeff Zucker
Bryson, Stewart wrote: I appreciate your help Jeff. The pragma you specified does not correct the issue I'm getting the following error when I use your DBD::AnyData module: Wide character in print at /usr/local/lib/perl5/5.8.0/sun4-solaris/IO/Handle.pm Hmm, I'm guessing it's an issue with p

Re: Building 32bit DBD-Oracle under 64bit Oracle install

2004-02-05 Thread Tim Bunce
On Thu, Feb 05, 2004 at 09:14:13AM -0800, Lin Feng wrote: > Sean, > > I just tried it. It made no difference in my case: the Makefile generated > are exactly the same. > > Env: Solaris 2.8; Oracle 10.1.0.2.0; Perl 5.8.3 > > BTW, 'perl Makefile.PL' reports that it cannot determine correct Oracl

Re: Building 32bit DBD-Oracle under 64bit Oracle install

2004-02-05 Thread Tim Bunce
On Thu, Feb 05, 2004 at 04:21:40PM +, Sean Kelly wrote: > Hi, > > I think I've cracked it. The Makefile.PL in 1.15 is much better than the > one from 1.14 at detecting whether you need the lib32 Oracle directory from > a 64bit Oracle install but I think there is one flaw. > > On line 7

Re: can you help

2004-02-05 Thread Jeff Zucker
Bryson, Stewart wrote: I'm getting the following error when I use your DBD::AnyData module: Wide character in print at /usr/local/lib/perl5/5.8.0/sun4-solaris/IO/Handle.pm line 439 (#1) (W utf8) Perl met a wide character (>255) when it wasn't expecting one. That's not an error,

Migrating from ? to Oracle

2004-02-05 Thread Wiliam Stephens
Hi I'm going to be working on a Perl app using a database through the DBD set of drivers. The end production machine will run Oracle for which there is already DBD::Oracle. However, we don't have access to Oracle locally and wish to use a replacement for the bulk of the development process bef

Re: Building 32bit DBD-Oracle under 64bit Oracle install

2004-02-05 Thread Lin Feng
Sean, I just tried it. It made no difference in my case: the Makefile generated are exactly the same. Env: Solaris 2.8; Oracle 10.1.0.2.0; Perl 5.8.3 BTW, 'perl Makefile.PL' reports that it cannot determine correct Oracle version. I guess it does not know what to do with the two gidit in '10'.

Building 32bit DBD-Oracle under 64bit Oracle install

2004-02-05 Thread Sean Kelly
Hi, I think I've cracked it. The Makefile.PL in 1.15 is much better than the one from 1.14 at detecting whether you need the lib32 Oracle directory from a 64bit Oracle install but I think there is one flaw. On line 74 $::opt_r is set to a default value of "build". This value is causing $

Re: Named placeholders in DBD::Oracle - bug report

2004-02-05 Thread Tim Bunce
On Thu, Feb 05, 2004 at 10:50:46AM +, Charles Jardine wrote: > > I have just downloaded DBD::Oracle 1.15. I discover that the > patch below, which was intended to fix this problem, is not > included in the new release. I am sorry that I did not find > the time to check this at the release-cand

Re[2]: DBI bug - trailling blank LINES truncated from bind data

2004-02-05 Thread christopher
Hi Mac, I'm not talking about spaces - I'm talking about lines. in perl speak - specifically - put this into a bind variable then into a table:- "foo\r\n\r\n" then when you get it out again, you get this:- "foo" ... and even if I *was* talking about spaces, it's still a bug for

Re: Named placeholders in DBD::Oracle - bug report

2004-02-05 Thread Charles Jardine
Tim Bunce wrote: Thanks for the info and the patch! Tim. On Fri, Oct 17, 2003 at 02:07:46PM +0100, Charles Jardine wrote: The problem: --- When Oracle matches placeholder names passed to OCIBindByName() with the actual placeholders in the SQL or PL/SQL, it uses a case-insensitive compar

Re: DBI bug - trailling blank lines truncated from bind data

2004-02-05 Thread Michael A Chase
On 02/04/2004 09:39 PM, [EMAIL PROTECTED] wrote: Executing this:- UPDATE BLAH SET TRANSLATION=? WHERE ROWID=? used always to work for me, but after a recent upgrade, I notice that trailing blank lines are getting truncated during this update. Executing this statement instead, and the proble

RE: Problem using variable as a table name (prepare) - SOLVED

2004-02-05 Thread Paulo Ferreira
Hi, there! I tried the code and the result was the same. But then, I remembered having problems with the LANG environment variable - my system, a RH9 machine, has LANG set to en_US.UTF-8 - I set it to en_US, ran the program again and it worked perfectly !! So, my problem is solved! Thank you f

Re: W32.Novarg.A@mm

2004-02-05 Thread Tim Bunce
Most modern viruses, including this one, fake From addresses. Tim. On Thu, Feb 05, 2004 at 09:21:32AM +0100, [EMAIL PROTECTED] wrote: > Hi Tim, > > recently I got a mail from our administration that a '[EMAIL PROTECTED]' > send me a mail with 'message.zip' attached to it containing the mail worm

W32.Novarg.A@mm

2004-02-05 Thread michael . krips
Hi Tim, recently I got a mail from our administration that a '[EMAIL PROTECTED]' send me a mail with 'message.zip' attached to it containing the mail worm [EMAIL PROTECTED] I can't belive you sent it. What about that? bye mike

DBD::SQLite under Windows

2004-02-05 Thread Ron Savage
In comp.lang.perl.modules, Message-ID: <[EMAIL PROTECTED]>, Eric Bohlman has just posted this comment: -><8- DBD::SQLite was crashing perl under Windows (ActiveState build 629 on Win98SE) whenever ChopBlanks was set.  The crash was occurring in sqlite_st_fetch() in dbdimp.c when if (chopB