On 20 March 2014 17:43, Hayes, Michael <michael.ha...@credit-suisse.com> wrote: > Hi, > > I’m struggling to find an example of calling a more complex oracle stored > proc using soci. > > Could somebody please reply with the C++ code required to call the following > Oracle stored procedure: > > procedure get_stuff_for_user > ( > p_name in varchar2, > p_location in varchar2, > p_age in number, > p_records out refcursor > )
Michael, I'm not a solid Oracle user myself, but kong time ago, there was a similar question asked: http://sourceforge.net/p/soci/mailman/message/23752861/ It refers to code example in the Oracle tests, see test4: https://github.com/SOCI/soci/blob/4fe67b0c404e0e989b928662ff23c2e56fdc0e20/src/backends/oracle/test/test-oracle.cpp#L207-L214 I *suppose*, you might be able to bind refcursor as in the test, into statement object. Best regards, -- Mateusz Łoskot, http://mateusz.loskot.net ------------------------------------------------------------------------------ Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/13534_NeoTech _______________________________________________ soci-devel mailing list soci-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/soci-devel
