Ohk.. Thank you. Another 2 more clarifications
1) can i call a specific function which is specific to a database from any SOCI function. Can you also shed a little more details on the getbackend() function apart from the explanation in the documentation of SOCI. Probably a program for the same would be helpful. 2) can i throw user defined exceptions in the try block so that one of the catch blocks can handle it. For example if a query does not return any rows. I need to throw an exception and perform further action on it. Will this be possible? Sent from my iPhone. Brevity may be excused. Thank You. Regards, Medhavi Mahansaria. > On 28-Nov-2014, at 2:10 pm, Mateusz Loskot <mate...@loskot.net> wrote: > > 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 ------------------------------------------------------------------------------ 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
