I don't think you can do that. While savepoints let you roll a transaction back to a specified point, each sql statement is still atomic and the only way to call a function is within a sql statement. >>> "Mahesh S." <smahesh@xxxxxxxxxxxxxx> 4/30 3:08 am >>> Ian, I want to use a separate function to commit and rollback the transactions. If possible can I get a small example? Thanks and regards Mahesh ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
