develog

DECLARE V_SQL VARCHAR2(512); V_CURSOR NUMBER; V_EXECUTED NUMBER; V_COL1 TB_TEMP.COL1%TYPE; V_COL2 TB_TEMP.COL2%TYPE; V_COL3 TB_TEMP.COL3%TYPE; BEGIN V_SQL := ' SELECT COL1, COL2, COL3 FROM TB_TEMP WHERE COL4 = :1 AND COL5 = :2 '; --1. 커서 오픈 V_CURSOR := DBMS_SQL.OPEN_CURSOR; --2. SQL 파싱 DBMS_SQL.PARSE(V_CURSOR, V_SQL, DBMS_SQL.NATIVE); --3. 변수 바인딩 DBMS_SQL.BIND_VARIABLE(V_CURSOR, '1', 'AAA'); DBM..