dcsimg
Ant Display [sql] -1 rows affected
0 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   pankaj_kumar
Posted On:   Friday, September 8, 2006 08:09 AM

Hi I am running some pl/sql statements programs using ANT. But in display I am getting very unique result which I am unable to understad, nor any online info helped me in this regards. Following is the result which is displayed Claims_schema: [sql] connecting to jdbc:oracle:thin:@111.12.14.145:1521:PLMSRET [sql] Loading oracle.jdbc.driver.OracleDriver using system loader. [sql] Executing file: C:softwarepkmtestUPDATE_LOSS_LOC_JRSDCTN_CD.sql [sql] SQL: declare cursor sel_cur is select cc.clm_case_no, f.FEATR_NO, w. LOSS_LOC_JURSDCTN_CD from clm_case cc, clm_wc w, feature f where cc.curr_row_ind ='A' and cc.LOSS_TYP_CD ='WC' and cc.clm_case_no =w.clm_case_no and w.curr   More>>

Hi

I am running some pl/sql statements programs using ANT. But in display I am getting very unique result which I am unable to understad, nor any online info helped me in this regards.

Following is the result which is displayed

			
Claims_schema:
[sql] connecting to jdbc:oracle:thin:@111.12.14.145:1521:PLMSRET
[sql] Loading oracle.jdbc.driver.OracleDriver using system loader.
[sql] Executing file: C:softwarepkmtestUPDATE_LOSS_LOC_JRSDCTN_CD.sql
[sql] SQL: declare cursor sel_cur is select cc.clm_case_no, f.FEATR_NO, w.
LOSS_LOC_JURSDCTN_CD from clm_case cc, clm_wc w, feature f where cc.curr_row_ind
='A' and cc.LOSS_TYP_CD ='WC' and cc.clm_case_no =w.clm_case_no and w.curr_row_
ind ='A' and w.CLM_CASE_NO =f.CLM_CASE_NO and f.curr_row_ind ='A' and f.LOSS_LOC
_JURSDCTN_CD is null and w.LOSS_LOC_JURSDCTN_CD is not null; var_cnt NUMBER :=0
; begin for cur_rec in sel_cur loop update feature set LOSS_LOC_JURSDCTN_CD =cur
_rec.LOSS_LOC_JURSDCTN_CD where featr_no =cur_rec.FEATR_NO and curr_row_ind ='A'
; var_cnt := var_cnt + 1; end loop; DBMS_OUTPUT.PUT_LINE('Number of records upda
ted ' || to_char(var_cnt)); COMMIT; exception when others then DBMS_OUTPUT.PUT_L
INE('Error Occured ' || SQLERRM); ROLLBACK; end; /
[sql] -1 rows affected
[sql] Commiting transaction
[sql] Commiting transaction
[sql] 1 of 1 SQL statements executed successfully

Create_database_Conection:
[sql] connecting to jdbc:oracle:thin:@111.12.14.145:1521:PLMSRET
[sql] Loading oracle.jdbc.driver.OracleDriver using system loader.
[sql] Executing file: C:softwarepkmtestDIARY_TASK_STATE_UPDATE.sql
[sql] SQL: DECLARE CURSOR sel_cur IS SELECT a.task_id, a.task_state FROM d
y_task a, dy_task_attribute b WHERE a.task_id = b.task_id AND b.NAME ='TASK_STAT
E' AND TO_CHAR (b.VALUE) <> a.task_state; var_idx NUMBER := 0; BEGIN FOR cur_rec
IN sel_cur LOOP UPDATE dy_task_attribute SET VALUE =TO_CHAR (cur_rec.task_state
) WHERE task_id = cur_rec.task_id AND NAME ='TASK_STATE'; var_idx := var_idx + 1
; END LOOP; dbms_output.put_line('Updated ' || to_char(var_idx) || ' records');
COMMIT; EXCEPTION WHEN OTHERS THEN DBMS_OUTPUT.put_line (SQLERRM); ROLLBACK; END
; /
[sql] -1 rows affected
[sql] Commiting transaction
[sql] Commiting transaction
[sql] 1 of 1 SQL statements executed successfully

BUILD SUCCESSFUL
Total time: 1 minute 0 seconds


Please suggest something which can help me. I want to see how many records are actually updated.

!!! Thanks in advance !!!    <<Less
About | Sitemap | Contact