in reply to Re: Class::DBI / Oracle date field Q
in thread Class::DBI / Oracle date field Q

How? That's just a scalar variable. The SQL it contains may work on its own, but it won't in the OPs context.
  • Comment on Re: Re: Class::DBI / Oracle date field Q

Replies are listed 'Best First'.
Re: Re: Re: Class::DBI / Oracle date field Q
by dba (Monk) on May 07, 2004 at 18:27 UTC
    There might be a straightforward way, however the workaround will be to issue sql alter session set nls_date_format='DD/MON/YYYY'; and then your insert/update.
[reply]
[d/l]

In Section Seekers of Perl Wisdom