SQL & PL/SQL

Hi,

I have to insert spatial data into tables, but because the decimal symbol of te coordinates is a ',' he wont insert the data.
Now I wrote a trigger for it, but it doesn't work. Does anybody know a solution?

Here is the trigger I wrote (mn_00 is the name of the table en geom is the name of the column)

create or replace trigger tr_chkkomma
before insert or update on mn_00
for each row
BEGIN
IF position('.' in :new.geom)
THEN
replace(:new.geom, '.', ',')
END IF;
END;


Thanks in advance!