From: kunal kabra
Date: November 18 2008 2:04pm
Subject: how to execute stored procedure in c++
List-Archive: http://lists.mysql.com/plusplus/8165
Message-Id: <59636229F9874EAA8A1D61F2328EFCE2@RTEC.IND.RIL.COM>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0033_01C949B4.B6DBF860"

------=_NextPart_000_0033_01C949B4.B6DBF860
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

 

 

Hi,

 

I want to execute stored procedure in c++.

 

I have used 

            mysqlpp::Query query_voucher(lp_objConnection->query())

 

            mysqlpp::StoreQueryResult p_voucher_info =
query_voucher.store();

or         

mysqlpp::UseQueryResult p_voucher_info = query_voucher.use();

            

but it results me p_voucher_info ==0.

 

If I am using 

            bool res = query_voucher.exec();

or

            mysqlpp::StoreQueryResult p_voucher_info =
query_voucher.store();

 

then it results positve output i.e query executed.

 

I want to execute stored procedure which takes 3 parameters as input and
returns 5 parameters as output.

 

Please help me to solve this issue.

 

Thanking You,

Kunal K. Kabra

Rancore Technologies (P) Ltd.

Extn: 76892

Mobile: 9987582692

 

 


------=_NextPart_000_0033_01C949B4.B6DBF860--