Thank you. Your approach helped me in coming up with an approach. Is the use of statement costlier that just a session object? Does using statement over a session object have an impact on performance?
Sent from my iPhone. Brevity may be excused. Thank You. Regards, Medhavi Mahansaria. > On 28-Nov-2014, at 7:01 pm, Mateusz Loskot <[email protected]> wrote: > > On 28 November 2014 at 14:19, Medhavi Mahansaria > <[email protected]> wrote: >> 1) can i call a specific function which is specific to a database from any >> SOCI function. > > You need to be more specific on what kind of function you mean: > You should be able to call any backend-specific SQL function as part > of SQL statement. > SOCI is just a wrapper on top of a client C/C++ library accessing > particular backend, > so obviously you can't tell SOCI to call any extra C/C++ functions. > >> 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. > > There is not much to say more than in here, really > http://soci.sourceforge.net/doc/3.2/reference.html > http://soci.sourceforge.net/doc/3.2/backends/oracle.html > and here, see "Beyond SOCI API" > http://soci.sourceforge.net/doc/3.2/beyond.html > >> 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? > > {session|statement}::got_data() might help > > if (!sql.got_data()) throw ... > > or I don't understand the problem. > > 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 > [email protected] > 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 [email protected] https://lists.sourceforge.net/lists/listinfo/soci-users
