On 28 November 2014 at 07:04, Medhavi Mahansaria <medhavi1...@yahoo.co.in> wrote: > > The SAVEPOINT concept worked for me. Thanks a tonn!!
Good to know. > It would be of great help if you can help me out on how to release locks on > tables and resources in SOCI.. You need to use SAVEPOINT counterparts, that is COMMIT or ROLLBACK. AFAIR, in SQL (not embedded SQL) COMMIT releases all locks and erases related savepoint. Check Oracle docs for details. Simply, you need to translate your embedded SQL statements to plain SQL. Best regards, -- Mateusz Loskot, http://mateusz.loskot.net ------------------------------------------------------------------------------ Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration & more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk _______________________________________________ soci-users mailing list soci-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/soci-users
