Zabbix 1.4.5: Errors on creating schema with Oracle9i

[swullb]

Zabbix 1.4.5
Oracle9i (9.2.0.8)

When running the script create/schema/oracle.sql the following errors occur:

Error starting at line 163 in command:
CREATE TABLE history_sync (
	id		number(20)			,
	nodeid		number(20)		DEFAULT '0'	NOT NULL,
	itemid		number(20)		DEFAULT '0'	NOT NULL,
	clock		number(10)		DEFAULT '0'	NOT NULL,
	value		number(20,4)		DEFAULT '0.0000'	NOT NULL,
	PRIMARY KEY (id)
)
Error at Command Line:163 Column:0
Error report:
SQL Error: ORA-01722: Ungültige Zahl
01722. 00000 -  "invalid number"
*Cause:    
*Action:

Error starting at line 171 in command:
CREATE INDEX history_sync_1 on history_sync (nodeid,id)
Error at Command Line:171 Column:0
Error report:
SQL Error: ORA-00942: Tabelle oder View nicht vorhanden
00942. 00000 -  "table or view does not exist"
*Cause:    
*Action:

Error starting at line 230 in command:
CREATE TABLE history (
	itemid		number(20)		DEFAULT '0'	NOT NULL,
	clock		number(10)		DEFAULT '0'	NOT NULL,
	value		number(20,4)		DEFAULT '0.0000'	NOT NULL
)
Error at Command Line:230 Column:0
Error report:
SQL Error: ORA-01722: Ungültige Zahl
01722. 00000 -  "invalid number"
*Cause:    
*Action:

Error starting at line 235 in command:
CREATE INDEX history_1 on history (itemid,clock)
Error at Command Line:235 Column:0
Error report:
SQL Error: ORA-00942: Tabelle oder View nicht vorhanden
00942. 00000 -  "table or view does not exist"
*Cause:    
*Action:

Error starting at line 272 in command:
CREATE TABLE trends (
	itemid		number(20)		DEFAULT '0'	NOT NULL,
	clock		number(10)		DEFAULT '0'	NOT NULL,
	num		number(10)		DEFAULT '0'	NOT NULL,
	value_min		number(20,4)		DEFAULT '0.0000'	NOT NULL,
	value_avg		number(20,4)		DEFAULT '0.0000'	NOT NULL,
	value_max		number(20,4)		DEFAULT '0.0000'	NOT NULL,
	PRIMARY KEY (itemid,clock)
)
Error at Command Line:272 Column:0
Error report:
SQL Error: ORA-01722: Ungültige Zahl
01722. 00000 -  "invalid number"
*Cause:    
*Action:

Error at Command Line:602 Column:0
Error report:
SQL Error: ORA-01722: Ungültige Zahl
01722. 00000 -  "invalid number"
*Cause:    
*Action

What's up with that?

Changing 0.0000 to 0 does help.

But what to do with '99.9' ? Setting to '99' ?

Solution: Changing '99.9' to '99,9'.

Maybe it's because I use Oracle SQL Developer in a german language environment. And in German language the decimal point is a comma.