깨비네 마을 ~ 'ㅁ'/

ORA-29250: Invalid index specifed in call to dbms_sql.bind_array Cause: An invalid index was specified in a call to bind_array of dbms_sql. The index may have been null or of an improper value. Action: Correct the index value by modifying your PL/SQL program and try the bind_array call again. ORA-29251: Index1 is greater than Index2 in call to dbms_sql.bind_array Cause: The value of index1 was g..

[에러] ERROR at line 1: ORA-32313: REFRESH FAST of "SWSIS"."TA_E012_MV" unsupported after PMOPs ORA-06512: at "SYS.DBMS_SNAPSHOT", line 820 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 877 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 858 ORA-06512: at "SWSIS.JU_TMP", line 851 ORA-06512: at line 1 ORA-32313: REFRESH FAST of "string"."string" unsupported after PMOPs Cause: A Partition Maintenance Operation (P..

1) create session 권한을 주지 않아서 에러날 경우 이거나 비밀번호, 유저명을 잘못 쓴 경우~ system/password 로 접속후 SQL> grant connect, resource to sw ; Grant succeeded. 2) 재접속 [웬만하면 이걸로 다 해결!!!]

먼저, 1) ue_insert에 순차적으로(마지막row추가) 입력하게 한다 /*===========================================================================*/ /* Event : ue_insert */ /* Description : 추가버튼 클릭시 발생 */ /* Update : 수정불가 */ /*===========================================================================*/ String ls_yymm, ls_div long ll_cur_row, ll_row_count if dw_entry.AcceptText() 1 then return ls_yymm = String(dw_1.object..

해당 datawindow의 constructor event This.of_SetBase(True) This.of_SetSort(True) This.inv_base.of_SetColumnNameSource(2) // header로 sort This.inv_sort.of_SetUseDisplay(True) // dddw같은 경우 display value로 sort This.inv_sort.of_SetColumnHeader(True) // DATAWINDOW COLUMN을 자동으로 Modify Integer i, li_column_count String ls_column_name, ls_modify li_column_count = Integer(This.Describe("DataWindow.Column.Cou..

Select * From v$locked_object Where oracle_username = 'hsgrsyu' ; Select * From v$locked_object ; Select * From v$session Where sid = '94' Alter system kill session '94,11914';

String ls_path, ls_file blob blob_image, blob_temp long Job, ll_filelen integer li_x, li_y, net, li_loop, i Integer ll_file String ls_yymm Long ll_cnt, ll_chk pointer oldpointer // Declares a pointer variable ls_yymm = String(dw_1.object.yymm[1], 'yyyymm') if isnull(ls_yymm) or trim(ls_yymm) = '' then messagebox("알림", "DOWNLOAD할 년월을 입력하세요") return 1 end if select count(*) into :ll_cnt from tb_ta..

[ 파일 업로드 ] blob blob_temp, blob_tot integer li_filenum, li_index, li_loop String ls_file, ls_filename long ll_filelen, ll_read String ls_yymm Long ll_cnt, ll_rtn pointer oldpointer // Declares a pointer variable ls_yymm = String(dw_1.object.yymm[1], 'yyyymm') if isnull(ls_yymm) or trim(ls_yymm) = '' then messagebox("알림", "UPLOAD 대상 년월을 입력하세요") return 1 end if oldpointer = SetPointer(HourGlass!) ..

사용 설명서는 첨부 파일에서 다운로드 받으세요!

세금을 한꺼번에~~~ http://www.giro.or.kr/싸이트에서 회원 가입 후 공인인증서를 통해~ 세금을 납부 할수 있습니다~