Database

CString cstrTmp;cstrTmp = 
"CREATE OR REPLACE PROCEDURE \"DoSomething\" \r\n" 
"(\r\n" " pTxt nvarchar2\r\n" ")\r\n" 
"as\r\n" 
"\r\n" 
"vXml XmlType;\r\n" 
"vTempCounter int;\r\n" 
"\r\n" "begin\r\n" 
"     --my comment\r\n"
"     dbms_output.put_line('test'); 
"end;\r\n"

//where cBuffer is the query above
if(pCommand == NULL) 
{ 
     pCommand.CreateInstance(__uuidof(Command)); 
     pCommand->CommandType = adCmdText; 
} 
pCommand->CommandText= _bstr_t(*cBuffer); 
pCommand->CommandTimeout = m_pConn->CommandTimeout; 
pCommand->ActiveConnection = m_pConn; 
pCommand->Execute(NULL, NULL, adExecuteNoRecords); 
pCommand = NULL;

CREATE OR REPLACE PROCEDURE "DoSomething"(pTxt nvarchar2)asvXml XmlType;vTempCounter int;BEGIN     --myComment     dbms_utput.put_line('test');END;

CREATE OR REPLACE PROCEDURE "DoSomething"
(pTxt nvarchar2)
asv
Xml XmlType;
vTempCounter int;
BEGIN 
     -- my comment
     dbms_output.put_line('test');
END;

select distinct (select top 1 CLAIMMASTERID from ClaimMaster where encounterid='87B6D11C-3680-44A5-B1DB-AB16B3907AA6') ,EVC.EncounterID,EVC.CPT,(select (select ICDCode + ',' as [text()] from VisitTypeICDCPT soi where soi.VisitTypeID = t.VisitTypeID and VisitTypeID=VTI.VisitTypeID and encounterid='87B6D11C-3680-44A5-B1DB-AB16B3907AA6' order by VisitTypeID for xml path( '' )) from (select distinct VisitTypeID from VisitTypeICDCPT where VisitTypeID=VTI.VisitTypeID and encounterid='87B6D11C-3680-44A5-B1DB-AB16B3907AA6') as t )DiagnosisCode,EVC.Fee,convert(varchar(10),'2010-12-14 00:00:00.000',101) from EncounterVisitCode EVC inner join VisitTypeICDCPT VTI on EVC.encounterid=VTI.encounterid where EVC.encounterid='87B6D11C-3680-44A5-B1DB-AB16B3907AA6'