I use a trigger to generate an autonumber ID field:
CREATE OR REPLACE TRIGGER TEST BEFORE INSERT ON MyTABLE
FOR EACH ROW BEGIN
SELECT MySEQ.nextval INTO :new.ID from DUAL;
END;
I want to get the value of the id generated in my PHP script.
I am using PHP4 with OCI8.
thanks in advance. Daniel.
CREATE OR REPLACE TRIGGER TEST BEFORE INSERT ON MyTABLE
FOR EACH ROW BEGIN
SELECT MySEQ.nextval INTO :new.ID from DUAL;
END;
I want to get the value of the id generated in my PHP script.
I am using PHP4 with OCI8.
thanks in advance. Daniel.