Re: Setting session stuff

[prev] [thread] [next] [Date index for 2004/08/01]

Not to reply to myself, but is this OK?

__PACKAGE__->set_db('Main',$dsn,$username,$password,{AutoCommit=>1});
my $dbh = __PACKAGE__->db_Main;
$dbh->do(q[alter session set nls_date_format = 'yyyy/mm/dd hh24:mi:ss']);

----- Original Message ----- 
From: "Jay Strauss" <me@xxxxxx.xxx>
To: "class dbi" <cdbi-talk@xxxxxx.xxxxx.xxx>
Sent: Sunday, August 01, 2004 3:29 PM
Subject: Setting session stuff


> Hi,
> 
> Sorry I haven't used Class::DBI in a while and don't remember 
> anything.
> 
> If, in my CDBI base class, I have:
> 
> __PACKAGE__->set_db('Main',$dsn,$username,$password,{AutoCommit=>1});
> 
> How would I do:
> 
> $dbh->do(q[alter session set nls_date_format = 'yyyy/mm/dd hh24:mi:ss']);
> 
> at this stage?
> 
> Thanks
> Jay