How to call Stored procedure in VC++

[maharaja pandian]

hi, I have one clarification, I just want to know how to call stored procedures in CDaoDatabase. After the submit button I need to call one stored procedure by name STORE_PROCEDURE1 with input parameters as name,no,mark1,mark2 By using ADO I think we can use like this below. I just want to know how to use in DAO. With AdoComm .CommandText = "{call PROEX.KPP_LFE.PPP_INSTPP_EMBARQUE_AUX(?)}" .CommandType = adCmdStoredProc Set AdoParamRet = .CreateParameter("Retorno", adBSTR, adParamInputOutput, , vfRsEmb) Call .Parameters.Append(AdoParamRet) .Properties("PLSQLRSet") = True Set vfRsEmbRet = .Execute i want to do the same thing in DAO using CDaoDatabse Try again and again, At last you will say I don't know the meaning for impossible.,.

[Hamid Taebi]

When you send a "New Message" we can see it and you don't need to send a new thread_**

---

**_

whitesky

---

[Sarath C]

Can't this help you?[^] Or this search?[^] SaRath.
"It is your attitude, not your aptitude, that determines your altitude - Zig Ziglar." My Blog | Understanding State Pattern in C++