[SQL ] -501的問題
不知為什麼
紅字部份 有時會出現-501
但我程式明明就做OPEN與CLOSE不曉得哪裡有問題
是否有人可以給我一個方向呢
內容/問題描述:
long rc = RC_OK;
memset( HV_BUFFER , '\0', sizeof( HV_BUFFER ) );
strcpy( HV_BUFFER,"SELECT CHAMBER_ID FROM"
" DI.MM_PCD_WAFERCHAMBER"\
strcat( HV_BUFFER, " ORDER BY CLAIM_TIME DESC" );
strcat( HV_BUFFER, " FOR READ ONLY" );
//--------------------------
// SQL
//--------------------------
EXEC SQL PREPARE PRE_PCD_CHAMBER FROM :HV_BUFFER;
if ( SQLCODE != 0 )
{
return SQLCODE;
}
EXEC SQL DECLARE PCD_CHAMBER CURSOR FOR PRE_PCD_CHAMBER;
EXEC SQL OPEN PCD_CHAMBER;
if( SQLCODE != 0 )
{
return SQLCODE;
}
memset( hCHAMBER , '\0', sizeof(hCHAMBER ) );
EXEC SQL FETCH PCD_CHAMBER INTO :hCHAMBER
;
Long retSqlCode = SQLCODE;
EXEC SQL CLOSE PCD_CHAMBER;
SQLCODE = retSqlCode ;
if( SQLCODE != 0 )
{
if ( SQLCODE == 100 )
{
return 2;
}
return SQLCODE;
}
return RC_OK;
}
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 180.177.156.249
※ 文章網址: https://www.ptt.cc/bbs/Database/M.1422889172.A.940.html