Hello:



I have created a data entry form to insert data into oracle database.  I

want that the entred data to be posted to the relevant columns in one of

the tables and commit when the user presses the 'submit' button.



My sql statement reads like - 

Insert into Table_one (id, last_name, first_name, type_code, entry_date, 

entry_user)

values(seq_id.nextval, ::Last name::, ::First Name::, ::Type Code::,

sysdate, user)



Thanks in advance for help.

Sastry