Last updated - 2 April 2003

Overview

This is a project planning and status page for the effort of making OpenACS run on Oracle 9. People working in this area include Dirk Gomez and Mohan Pakkurti. More info will be posted soon.

List of Problems

• NLS_DATE_FORMAT woes
  My Oracle 9.2 instance doesn't have "YYYY-MM-DD" as the default date in its init.ora. The usual way to set the date format properly for OpenACS was to set an environment variable in nsd-oracle (or in /etc/profile). This doesn't work anymore.
  This sequence of steps works as expected in Oracle 8, but not in Oracle 9:
  

  
    export NLS_DATE_FORMAT="YYYY-MM-DD"
    sqlplus foo/bar
    select sysdate from dual; 
  
    export NLS_DATE_FORMAT="YY-MON-DD"
    sqlplus foo/bar
    select sysdate from dual; 
  
  
  

  
  (Posted by Dirk on 2-April-2003, not yet resolved)