Re: Why won't my script terminate?

2004-03-25 Thread Jan Matejka
I have encountered identical problem if I used DBD-Oracle having version 1.12 in Windows environment (Windows 2000/XP) with ActiveState perl 5.6.x/5.8.x. So I am running DBD-Oracle 1.12 - it works without any problems. I don't know, if this behavior is windose specific. MaT

Re: Why won't my script terminate?

2004-03-25 Thread Tim Bunce
On Wed, Mar 24, 2004 at 04:08:17PM -0500, Laurie Vien wrote: Thank you very much to everyone who replied. The combination of your answers put me on the right path; I got it! I moved the $sth-finish(); up to right after the close of the While loop, instead of leaving it at the end of the

RE: Why won't my script terminate?

2004-03-25 Thread Hardy Merrill
Wow, I was way off! - quote from Dumb and Dumber. Like I said, Ronald is much more knowledgable than I :-) Hardy Ronald J Kimball [EMAIL PROTECTED] 03/24/04 04:50PM The $sth-finish() isn't doing anything; there's an implicit $sth-finish() when $sth-fetchrow_hashref() gets to the end of the

Re: Why won't my script terminate?

2004-03-25 Thread Stephan Harren
And by the way, you shouldn't use $sth-finish() anyway, except for when you know exactly that you really, really need it. Usually this is being done for you, so using it might just hide errors and misbehaviour. Best regards, Stephan Hardy Merrill wrote: Wow, I was way off! - quote from

DBI handle has uncleared implementors data

2004-03-25 Thread Rajdeep Singh CHIMNI
Hi people, Having a problem with a script that connects to a mysql db and generates a png graph. When i run it i get the desired result but i also get the following error Name DBIx::Chart used only once: possible typo at gp line 8. DBI handle has uncleared implementors data at gp line 16.

RE: Why won't my script terminate?

2004-03-25 Thread Laurie Vien
I'd LOVE to do this if I had time, but it might have to wait a few days--part of the reason I write to the user list instead of figuring things out myself is time constraints. So I'll be glad to but I can't do it until at least the middle of next week. Laurie -Original Message- From:

RE: DBI handle has uncleared implementors data

2004-03-25 Thread Dean Arnold
1. Unfortunately, there's a bug in DBIx::Chart wrt PH's in the datasource part of the SQL statement, so I'm afraid at present PH's in that part of the query don't work. 2. No, you shouldn't need to explicitly finish() anything. 3. I tried to repro your problem, using another type of database,

RE: Why won't my script terminate?

2004-03-25 Thread Ronald J Kimball
By the way, Laurie mentioned to me off-list that she had an SQLPLUS session open so she could reset the value of the contribute_flag column. That could have led to the script blocking, as I supposed. I've done that myself quite a few times, forgetting to commit in SQLPLUS while testing a script.

RE: Why won't my script terminate?

2004-03-25 Thread Laurie Vien
But what I didn't tell you, Ronald, was that I *did* commit after my updates in the SQLPlus session ... I might have forgotten once, but my Perl script didn't produce any output unless I did the Commit; so that helped to remind me. So I don't think that was the problem after all. -Original

RE: Why won't my script terminate?

2004-03-25 Thread Dennis M. Gray
When faced when a similar problem I killed the script, ran it again and it worked fine. It usually happens at the end of the day when I want to go home but run the script just one more time. I think a table lock or network problems could be a reason too but would be interested in the results of

RE: DBI handle has uncleared implementors data

2004-03-25 Thread Rajdeep Singh CHIMNI
Hi , Thank you for clarifying on the place holders part . On the uncleared implementors part: a) I tried to repro your problem, using another type of database, and the data you listed, but get a failure in the chart rendering engine, apparently because the selection values you're specifying