Oracle RETURNING Clause - get identity of inserted row
PROCEDURE Ins (pContactID OUT Contacts.ContactID%TYPE, pFirstname IN Contacts.Firstname%TYPE, pSurname IN Contacts.Surname%TYPE) IS BEGIN INSERT INTO Contacts (fname, sname) VALUES (pFirstname, pSurname) RETURNING ContactID INTO pContactID; END;
Немає коментарів:
Дописати коментар