[php-konf] oracle - mysql_inserted_id
From: A. (enigma@mail.lt)
Date: 2002-12-09 19:10:27
bandau padaryt kazka vietoj mysql_inserted_id funkcijos - sukuriau lentele,
i kuria turetu buti irasoma is sekos paskutinio irasyto id reiksme
ar galima i trigeri taip irasyti update uzklausa ?
atrodo, klaidu nera, bet ismeta klaida:
OCIError: 4098 ORA-04098: trigger 'EXT_USER_054.TEST_TRIGGER' is invalid
and failed re-validation
trigerio sukurimo uzklausa :
CREATE OR REPLACE TRIGGER
test_trigger before insert on test for each row
begin
select test_seq.nextval into :new.id from dual;
update table_id SET id= test_seq.currval where tablename = 'test';
end;
