thanks a lot, got the solution quite some time back, but didn't find time to shoot the mail. the thing was working fine, only i cudn't see it in the table after the insert as i hadn't committed the transaction.

thanks and regards.