search for: nls_date_format

How can I pass the following Oracle 10g variables to my apache? ORACLE_BASE=/u01/oracle ORACLE_HOME=/u01/oracle/10g ORACLE_SID=king LD_LIBRARY_PATH=$ORACLE_HOME/lib LD_LIBRARY_PATH_32=$ORACLE_HOME/lib32 PATH=$PATH:$ORACLE_HOME/bin NLS_LANG=AMERICAN_AMERICA.AR8MSWIN1256; export NLS_LANG NLS_DATE_FORMAT=dd-mm-yyyy ; export NLS_DATE_FORMAT export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH LD_LIBRARY_PATH_32 PATH I start my apache through service httpd start... [root at king script]# ps -ef | grep apache apache 28494 15315 0 04:02 ? 00:00:01 /usr/sbin/httpd -k start apache 2849...

I have a table with "expires_on" a DATE field. "Show" and "Destroy" work, but "Edit" errors: /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_view/helpers/date_helper.rb:150:in `select_hour'' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_view/helpers/date_helper.rb:149:in `select_hour'' It only happens when

I''m seeing a behavior in Rails that I find very strange. Having worked quite a bit with Oracle with other languages I would always dutifully do ALTER SESSION SET NLS_DATE_FORMAT = <my_date_format> and ensure I use that date format in my application. With Rails I still have not figured out how to execute an ALTER SESSION statement after connecting to the database (I''m using the the jdbc adapter). And sure enough I get a "date format not recognized"...

Hi, I have a question about bundle: RoR + oracle + bind variables. Heaving read forums/blogs/etc I found out RoR does not use bind vars for oracle particularly (and for all adapters in general). Then I found Michael''s patch (http://dev.rubyonrails.org/attachment/ticket/5199/oracle_bind.patch) but it was not added to the following RoR versions (since the end of May). As I suppose it was

...uot; If I create the table manually in the oracle database and define data type "DATE" for "DATUM", I receive a error message after starting sqlUpdate and R shuts down. There must be problem with the date format. So I try the following: sqlQuery(channel,"alter session set NLS_DATE_FORMAT='YYYY-MM-DD'") Unfortunately without sucess. I tried a lot of variations with the format. In R I worked with as.Date or strptime, too. The error message is the following: "Failed exec in Update 22007...Fehler in Parameter 2: ?berlauf im Datetime-Feld" I don't know, if...