파워빌더에서 프로시져 등록하지 않고 바로 호출하기.
Oracle
______________________________________________________________________________
ls_sql ='EXECUTE SP_aaa(?,?,?,?,?,?)'
DECLARE splcall1 DYNAMIC PROCEDURE FOR SQLSA;
PREPARE SQLSA FROM :ls_sql USING sqlca;
EXECUTE DYNAMIC splcall1 USING :ls_a, :ls_b, :ls_c, :ls_d, :ls_e, :ls_f;
FETCH splcall1 INTO :ll_g, :ls_h;
-------------------------------------------------------------------------------
DB2
______________________________________________________________________________
ls_sql =" CALL CLVDTALB.SVIR02C0(?,?,?)"
DECLARE splcall1 DYNAMIC PROCEDURE FOR SQLSA;
PREPARE SQLSA FROM :ls_sql USING sqlca;
EXECUTE DYNAMIC splcall1 USING :ls_sdt_fr, :gs_emp_no, :ls_temp;
______________________________________________________________________________
