Oracle uses sequences and triggers, not just a null or zero like some other DB engines. See link for a short discussion. Details can be found in your local Oracle docs but this is at least mentioned in the module description.

I started with MySQL (which allows what you tried) and have had to deal with many issues with other DB's. Some people may recommend a higher-level DB interface but I've never used them personally.