Problem in using stored procedure with ADO
-
Hi to all, I am having one table having 2 BLOB fields and one varchar2 field in Oracle. i am implementing my code vc++ using ADO to connect to Oracle. i am using Stored procedure to retrieve BLOB data from Oracle. I am able to store BLOB data with Insert Command. but there is problem while using stored procedure to retrive image data. This is my code how i am using ADO paramUserid= pCommand->CreateParameter("p_UserID",adVarChar,adParamInput,50,_bstr_t(userid)); pCommand->Parameters->Append(paramUserid); paramLICODE= pCommand->CreateParameter("leftcode",adLongVarBinary,adParamOutput,retLsize+5); pCommand->Parameters->Append(paramLICODE); paramRICODE= pCommand->CreateParameter("rightcode",adLongVarBinary,adParamOutput,retRsize+5); pCommand->Parameters->Append(paramRICODE); pCommand->ActiveConnection=m_pConn; pCommand->CommandType = adCmdText; pCommand->CommandText="{ Call getIrisCodes(?,?,?) }"; pCommand->Execute(NULL,NULL,adCmdText); It is giving error like "Syntax error or Access violation" I have tried that stored procedure in Oracle. it works fine. because i am able to get the length of the images. but unable to get the image data. What should i do. Can anybody help me. Its very urgent. My whole project depends on this only. Thanks in advance.