Hi!
"Robert Kehl" <[EMAIL PROTECTED]> writes:
> 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: <ORA-00903: invalid table name (DBD
ERROR: OCIStmtExecute)>
dbi:Oracle:otrs>
>>> - 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: <ORA-01400: cannot insert NULL into
("OTRS"."TEST"."FOO") (DBD ERROR: OCIStmtExecute)>
dbi:Oracle:otrs>insert into test (foo) values (' ') /
Ok - 1 row affected
insert into test (foo) values (' ') : success
dbi:Oracle:otrs>
>>> (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.
_______________________________________________
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
