Hi >How would i know what id number get's created ? Izzit >by issueing seq_emp.currval ? If i issued this select >seq_emp.currval from my trigger how can i pass this >value to my web application ? Give a look to the RETURNING clause in the SQL Reference. HTH Chris -- //www.freelists.org/webpage/oracle-l