Hi all,

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.

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?

Florent,

_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev

Reply via email to