Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: VC8.0
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
Posted 23-Jan-11 20:24pm
Edited 23-Jan-11 20:53pm
v2
Comments
Emilio Garavaglia at 24-Jan-11 1:54am
   
added <pre> tags

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 295
1 DamithSL 265
2 CPallini 235
3 Maciej Los 190
4 George Jonsson 170
0 OriginalGriff 5,415
1 DamithSL 4,422
2 Maciej Los 3,820
3 Kornfeld Eliyahu Peter 3,470
4 Sergey Alexandrovich Kryukov 2,911


Advertise | Privacy | Mobile
Web04 | 2.8.141216.1 | Last Updated 24 Jan 2011
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100