목록PL/SQL (4)
Gentle Breeze
#include #include #include #define MAX_CNT 30 EXEC SQL BEGIN DECLARE SECTION; VARCHAR uid[80]; VARCHAR pwd[20]; VARCHAR db_string[20]; VARCHAR usr_pwd[80]; VARCHAR v_ent_dt[MAX_CNT][8+1]; VARCHAR i_mbrno[MAX_CNT][30]; VARCHAR v_name[MAX_CNT][14+1]; VARCHAR v_phone_num[MAX_CNT][30]; EXEC SQL END DECLARE SECTION; EXEC SQL INCLUDE SQLCA; int main() { int i = 0; int count = 0; int bfCount = 0; int e..
이 상황에서 자주 발생하는 Oracle Error Code 원문 - http://scruz.tistory.com/18 ORA-01002: fetch out of sequence ORACLE에서 제공하는 문서상의 원인과 해결방법은 아래와 같다. Cause: This error means that a fetch has been attempted from a cursor which is no longer vaild. Note that a PL/SQL cursor loop implicitly does fetches, and thus may also cause this error. There are a number of possible causes for this error, including: 1) Fetchi..
DECLARE v_dt DATE; BEGIN v_dt := TO_DATE ('19010101', 'yyyymmdd'); LOOP EXIT WHEN v_dt > TO_DATE ('21001231', 'yyyymmdd'); INSERT INTO BIZ_DATE_13 (DT, WEEK_DAY, HOLIDAY_YN) VALUES (TO_CHAR(v_dt, 'yyyymmdd') , TO_CHAR(v_dt, 'd') , DECODE((TO_CHAR(v_dt, 'd')), '1', 'Y', -- 일요일 '2', 'N', '3', 'N', '4', 'N', '5', 'N', '6', 'N', '7', 'Y', -- 토요일 'Y')); -- Fault Value v_dt := v_dt + 1; END LOOP; COMM..