oledb for oracle package

See more:

VC8.0

C++

hi
this the package which i want to execute
i assign the package Query in Cstring Querystr

CREATE PACKAGE DA.ST_DBK_DEFECTS IS
 ------------------------------------------------------------------------------

  -- FUNCTION Offer_Net_Duty_Rate

  -- Get the net duty rate, which is the sum of duties from st_offer_item_duties

  -- NOTE: this function does not populate st_offer_item_duties

  ------------------------------------------------------------------------------

  FUNCTION Get_Inv_Defect_String(

            p_inv_item_code IN da.ST_INV_ITEMS.INV_ITEM_CODE%TYPE

           ,p_comp_code     IN da.ST_INV_ITEMS.comp_code%TYPE

            ) RETURN VARCHAR2;

END St_Dbk_Defects;

my connection string
_ConnectionPtr		m_pConn;
_CommandPtr	        m_pCom,
m_pConn.CreateInstance (__uuidof(Connection));
	CString strConn ;
	strConn.Empty();
	m_pConn->CursorLocation = adUseClient;	
	strConn	=_T("Provider=OraOLEDB.Oracle.1;Persist Security Info=False;Extended Properties=\"\";Data Source =");
	strConn += DataSourceName +L";";
	try
	{
		m_pConn->Open(_bstr_t(strConn),_bstr_t("SYSTEM"),_bstr_t(PasswordName),adConnectUnspecified);
		
	}

its working fine and some other package execute correctly instead above package

m_pCom->CommandText = _bstr_t(Querystr);
m_pCom->Execute(NULL,NULL,adCmdText);

this execute return fine but not execute in oracle database whenever if i execute using command it execute in oracle please help me how to write the command property to execute the same;
your help will be appreciated
thanks
zulfi