다이나믹 SQL을 사용하였는데 아래와 같은 오류가 납니다...무엇을 잘못되었나요
EXEC SQL BEGIN DECLARE SECTION; char stmt[512]; EXEC SQL END DECLARE SECTION;
memset( stmt, 0x00 , sizeof(stmt) ); if( gArgc == 2 ) strcpy( stmt , "SELECT org_cd FROM EFMS_ORGMAST WHERE oper_gb='1' ORDER BY org_cd ASC" ); else if( gArgc == 3 ) sprintf( stmt , "SELECT org_cd FROM EFMS_ORGMAST WHERE oper_gb='1' AND org_cd = %s ORDER BY org_cd ASC",
gOpenOrgCd );
EXEC SQL PREPARE sql_stmt FROM :stmt;
EXEC SQL DECLARE cur_orgmast CURSOR FOR sql_stmt;
if ( SQLCODE != OK ) { FDUMP(PNAME, "%d:%s\n", SQLCODE, SQLERRM); return( NK ); }
오류내용:
-16843143:ct_dynamic(CURSOR_DECLARE): user api layer: external error: The specified id does not exist on this connection.
|