[SL] (no subject)

[Gabriel C M. <gmi...@qu...>]

i am running sl/1.8.4 (with the patch of the same version number) ...
debian woody with oracle9.0.0.1ee.

it seems like this alter session command (SL/Form.pm line 781)

###
ALTER SESSION SET NLS_DATE_FORMAT = 'MM-DD-YY'
###

isnt taking effect... and commands like this (for which there are many)
crash:

###
SELECT c.discount, c.creditlimit, c.terms,
                 c.email, c.taxincluded,
                 date '05-25-02' + c.terms AS duedate,
                 c.creditlimit - (SELECT SUM(a.amount - a.paid)
                                  FROM ar a
                                  WHERE a.customer_id = c.id
                                  GROUP BY a.customer_id) AS
creditremaining
                 FROM customer c
                 WHERE c.id = 10093 at SL/IS.pm line 878.
###

with this error...

###
DBD::Oracle::db prepare failed: ORA-01843: not a valid month (DBD ERROR:
OCIStmtExecute/Describe) at SL/IS.pm line 880.
Can't call method "execute" on an undefined value at SL/IS.pm line 882.
###

i can login as a the dataset user and excute this ditty ...

##
ALTER SESSION SET NLS_DATE_FORMAT = 'MM-DD-YY';
create table foo (ts date);
insert into foo (ts) values ('01-01-01');
select * from foo;
##

and get this as expected

###
TS
=========
1/1/2001
###

any help would be appreciated.


---
Gabriel Millerd| "I am just a simple man trying to make my way in the universe."
Sith Admin     |                     --Jango Fett, SW:AOTC