Re: Perl - connecting to Oracle

2008-05-21 Thread Tim Bunce
On Tue, May 20, 2008 at 07:44:33PM -0400, John Scoles wrote: No the * is DBI way of pointing to where the error is. Seems like a common misunderstanding. Perhaps the * should be changed to something like ERROR NEAR HERE Tim.

Re: Perl - connecting to Oracle

2008-05-21 Thread Paul Gallagher
Hi Tim, I don't think * is really an issue ... I understood Mike to be flagging staion_id as the probable typo (hence ORA-00904), not *. Paul http://tardate.blogspot.com On Wed, May 21, 2008 at 5:00 PM, Tim Bunce [EMAIL PROTECTED] wrote: On Tue, May 20, 2008 at 07:44:33PM -0400, John Scoles

RE: Perl - connecting to Oracle

2008-05-21 Thread Rick Frink
Hi, I always quote (qq) the select string to escape it from local interpretation, then feed it to the 'prapre' statement. Rick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tue 5/20/2008 4:04 PM To: dbi-users@perl.org Subject: Perl - connecting to

Re: Perl - connecting to Oracle

2008-05-21 Thread John Scoles
D'ho!! That is so funny!! I guess I really sounded like a smarty pants on that one!! Dyslexia and computer coding do not mix very well on my part. anyway I do not believe in Dog! Thanks for the morning laugh!! Paul Gallagher wrote: Hi Tim, I don't think * is really an issue ... I

Re: Perl - connecting to Oracle

2008-05-21 Thread Tim Bunce
Nevertheless, I've seen several instances of people not understanding that the * was added to the statement by DBD::Oracle as a marker when it reports the error. Changing it to something unambiguous would help. Tim. On Wed, May 21, 2008 at 05:42:17PM +0800, Paul Gallagher wrote: Hi Tim, I

Re: Perl - connecting to Oracle

2008-05-21 Thread John Scoles
I guess I can get that in for 1.22 Cheers John Scoles Tim Bunce wrote: Nevertheless, I've seen several instances of people not understanding that the * was added to the statement by DBD::Oracle as a marker when it reports the error. Changing it to something unambiguous would help. Tim. On

Forcing $dbh-disconnect to really disconnect

2008-05-21 Thread Jonathan Kamens
Greetings, I'm writing a Perl DBI script using the DBD::Pg driver. There's a point in the script at which I need to drop the database I'm working with and recreate it from some files that have been generated by the script. I'm calling the external dropdb and createdb programs to do this,

Please unsubscribe me from dbi mailing lists.

2008-05-21 Thread J . P . Park .
I apologize to write down this mail on the mailing list although it brakes the rule for mailing. Even though, I tried several times, non of method were worked to unsubscribe, I think that the mailing system has an error to unsubscript. Please check it and unsubscribe me.

Re: Forcing $dbh-disconnect to really disconnect

2008-05-21 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Unfortunately, the disconnect call apparently doesn't really disconnect, because the dropdb command fails with an error that other users are still connected to the database. This works fine for me. It's most likely that you have other