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