Hi

I have been looking for some examples of returning a Oracle REF_CURSOR
>From a Oracle Stored Procedure using the SOCI Interface C++ Library.

I have a test stored procedure:
CREATE OR REPLACE PROCEDURE da_get_users
   ( ptr_cursor OUT read_cursor_pack.readCursor )
AS

BEGIN

     OPEN ptr_cursor FOR
     SELECT da_user, da_type FROM DA_USERS ;

END da_get_users ;

In a C++ application how do I retrieve the out variable (ptr_cursor), then do I 
use a
Fetch() loop to retrieve the data from the select statement.

   Thanks
       Kurt

------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnnow-d2d
_______________________________________________
soci-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/soci-users

Reply via email to