Hi!
"Robert Kehl"
This wasn't an issue in our Oracle 9.2.1 release. Which Oracle version are you using?
We're running 9.2.0.1:
dbi:Oracle:otrs>create table session ( foo varchar(20) ) /
create table session ( foo varchar(20) ) : error:
- This patch to scripts/database/initial_insert.sql adds a (commented out) Oracle statement to disable substition variable scanning, which created problems for me when I piped it through sqlplus. It also changes the "empty answer" in standard_response from '' to ' ', since '' violates the NOT NULL constraint in Oracle:
Again, the latter hasn't been an issue so far. Thanks.
Strange. I'm guessing they've changed the behaviour between the
versions:
dbi:Oracle:otrs>create table test ( foo varchar(20) not null ) /
Ok - 0 rows affected
create table test ( foo varchar(20) not null ) : success
dbi:Oracle:otrs>insert into test (foo) values ('') /
insert into test (foo) values ('') : error:
(It might be a good idea to mention on the mailing list web page that you can't post to the dev list without being subscribed to it.)
We couldn't do better if we wanted the list members to be spammed all over, yes...
Note that I'm not complaining about the list being closed as such; I just think it would be a good idea to let people know about it without making them have to play the bounce-game first. :) Regards, -- Kristoffer.