You can use the RETURNING clause to do this in Oracle stored procs.
TABLEA has NAME and EMP_ID. EMP_ID is populated internally when records are inserted.
INSERT INTO TABLEA(NAME) VALUES ('BOB') RETURNING EMP_ID INTO o_EMP_ID;
That's assuming that line is in a stored proc with an output parameter of o_EMP_ID.
Hope that helps... if not, here's a more detailed example: