Insertion Error while multiple people insert the same table at same time

i am using one application.
Multiple user accessing the same application at the same time.
when multiple user trying to insert same table, users getting insertion error.
How to avoid this until the first user complete then only allowed the other user for insertion.
I am using sql statement for insertion..
pls. give suggestions...
...