i can not get the CLOB output from stored procedure
I am using C++ to get the CLOB output from stored procedure, but i got nothing also there was no exception occured. Can you please give me some suggestion?
i did as follow:
--------------------------------------------------------------------------------------------------------------------
TestRecordset .h
class TestRecordset : public CRecordset
{
public:
TestRecordset (CDatabase* pDatabase = NULL) ;
virtual ~TestRecordset () ;
DECLARE_DYNAMIC(TestRecordset )
public :
void Move( long nrows, WORD wfetchtype );
//{{AFX_FIELD(TestRecordset , CRecordset)
CString m_clobOutput;
//}}AFX_FIELD
//{{AFX_VIRTUAL(TestRecordset )
public:
virtual void DoFieldExchange(CFieldExchange* pFX) ; // RFX support
//}}AFX_VIRTUAL
};
--------------------------------------------------------------------------------------------------------------------
TestRecordset .ccp
IMPLEMENT_DYNAMIC(TestRecordset, CRecordset)
TestRecordset::TestRecordset(CDatabase* pdb) : CRecordset(pdb)
{
m_nDefaultType = snapshot;
m_nParams = 9 ;
m_strInKyotsu = "" ;
m_strInKobetsu = "" ;
m_strOutSysUpdUsr = "" ;
m_strOutSysUpdTermID= "" ;
m_strOutSysUpdTime = "" ;
m_strOutSyoriRC = "" ;
m_strOutIndata = "" ;
m_strOutCmt = "" ;
// m_strOutOutdata = "" ;
// m_strOutOutdata2 = "" ;
}
TestRecordset::~TestRecordset()
{
}
void TestRecordset::DoFieldExchange(CFieldExchange* pFX)
{
//{{AFX_FIELD_MAP(CABSRecordset)
pFX->SetFieldType(CFieldExchange ::outputParam); RFX_Text(pFX, "OutSysUpdUsr", m_strOutSysUpdUsr);
RFX_Text(pFX, "OutSysUpdTermID", m_strOutSysUpdTermID);
RFX_Text(pFX, "OutSysUpdTime", m_strOutSysUpdTime);
RFX_Text(pFX, "OutSyoriRC", m_strOutSyoriRC);
RFX_Text(pFX, "OutIndata", m_strOutIndata,500);
RFX_Text(pFX, "OutCmt", m_strOutCmt);
// RFX_Text(pFX, "OutOutdata", m_strOutOutdata, 15000);
//}}AFX_FIELD_MAP
}
void TestRecordset::Move(long nrows, WORD wfetchtype)
{
if (m_nFields)
CRecordset ::Move(nrows, wfetchtype);
else
m_bBOF = m_bEOF = true;
}