pl/sql developer 사용법 - pl sql developer test window cursor

 

 

 

 

 

 

 

after

 

grant debug connect session to <schema>

 

 

 

 

 

 

 

 

-- Created on 2013-10-10 by JEONKWANGSIK
 
declare 
   wk_cursor1 SYS_REFCURSOR;
   wk_cursor2 SYS_REFCURSOR;
begin

  open wk_cursor1 for     
    select  'test1' from dual ;

  :result1 := wk_cursor1;
 

 XXX.pc_ap_dr_select_pc('XXX','','',:wk_cursor2 ) ;
         
end;

 

 

add insert

=>

Enabled result1 Cursor <Cursor>
Enabled wk_cursor2 Cursor <Cursor>

 

 

 

 

 

 

 

Test Window Variable Type Value Check

 

 

result1

 

 

 

 

 

wk_cursor2