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
    )

Note the return type is oracle refcursor and there are 3 input parameters.

The return from this call will be a variable rowset of 3 elements:

// example of one row:       soci::dt_double,   soci::dt_string,    
soci::dt_string

Your help is greatly appreciated.

Many thanks,
Michael



=============================================================================== 
Please access the attached hyperlink for an important electronic communications 
disclaimer: 
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html 
=============================================================================== 

------------------------------------------------------------------------------
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

Reply via email to