trigger and autonumber value

wxdqz

New Member
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.
 
Back
Top