Hi Florent, Florent Guiliani schrieb:
I'm trying to install OTRS (cvs from today) with Oracle. The script initial_insert.sql is invalid with Oracle
The instruction: INSERT INTO valid (name, create_by, create_time, change_by, change_time) VALUES ('valid', 1, current_timestamp, 1, current_timestamp);
give an error: 14:20:58 ('valid', 1, current_timestamp, 1, current_timestamp); 14:20:58 * 14:20:58 ORA-00984: column not allowed here
current_timestamp doesn't exist, Oracle use instead sysdate.
It's working for me on Oracle 10.2.0 (I also used it in Oracle 9).
Starting from 2.0.4 who is not Oracle compatible, I'm using cvs and again the installation failed. I think that I will have much problems with OTRS and Oracle... It seems like Oracle is not used with OTRS and I should go with another database engine. What do you think about it?
It's working on Oracle. There are already users which use OTRS on Oracle a long time. :-) But you also can use other databases. :-)
Florent,
Martin ((otrs)) :: OTRS GmbH :: Europaring 4 :: D - 94315 Straubing Fon: +49 (0) 9421 1862 760 :: Fax: +49 (0) 9421 1862 769 http://www.otrs.com/ :: Communication with success!