Apache::DBI & Oracle Not Reconnecting

2003-10-09 Thread Levon Barker
END; " with ParamValues: :amt=undef] at /perl_modules/CurrencyManager.pm line 58. My understanding is that Apache::DBI is supposed to establish a new connection if the cached connection is invalid. Any thoughts on this would be great. Thanks, Levon Barker

DBI : Is this the right way to do it?

2003-10-23 Thread Levon Barker
d = shift; $sth->execute($id); my $title; $sth->bind_col( 1, \$title); $while ($sth->fetch) { } return $title; } END OF CODE SNIPPET ## When a user does cancel the request before the db access has finished, I get this in my error log the next time a user tries to call the page: Levon Barker <>

DBI : Is this the right way to do it?...

2003-10-23 Thread Levon Barker
ccess has finished, I get this in my error log the next time a user tries to call the page: ORA-03113: end-of-file on communication channel I am worried I havn't got my head arround the shared database handler concept. Any help would be appreciated. Thanks, Levon Barker <>

Is this the right way to do it? - More Data

2003-10-23 Thread Levon Barker
quest? Doesn't seem right. Original Message Subject: DBI : Is this the right way to do it?... From: "Levon Barker" <[EMAIL PROTECTED]> Date:Thu, October 23, 2003 12:49

Re: Is this the right way to do it? - More Data

2003-10-23 Thread Levon Barker
Thanks Perrin, your always full of good answers :) > On Thu, 2003-10-23 at 13:00, Levon Barker wrote: >> Should I be making new statement handlers for every new request? > > You don't have to, but if you don't and the Oracle connection gets lost > and Apache::DBI reco

mod_perl + perl/tk

2003-12-05 Thread Levon Barker
Hello, Can anyone point me to a reference on delivering a GUI to the browser with a mod_perl server. Perhaps with perl/tk. Can this be done? Has anyone done it? How would it work with mod_perl? Cheers, Levon Barker -- Reporting bugs: http://perl.apache.org/bugs/ Mail list info: http

RE: mod_perl + perl/tk

2003-12-05 Thread Levon Barker
> Hi there, Hey. > On Fri, 5 Dec 2003, Levon Barker wrote: > > > Can anyone point me to a reference on delivering a GUI to the > browser with a > > mod_perl server. > > I don't understand your question at all. Most browsers thesedays present > a graph