Deepak,
What is the values printed when you do
If it is non-zero then definitely your insert statement is working. I guess
it giving correct result when i giving select statement
means when you execute select you can actually see the data which you are trying to insert. If this is the case how can you say that your insert statement is not working?