ORACLE 中立即执行字符串及传入变量

立即执行跟着的方法，并把当前的变量用USING 传进去。 

EXECUTE IMMEDIATE         'BEGIN             Work_Order_Req_Line_Util_API.Create_Po_Allowed(:requisition_, :line_no_, :release_no_);          END;'      USING requisition_no_, line_no_, release_no_;

 

 

---------------------------------------------------------------------------------------------------

stmt_ := 'BEGIN                      Customer_Order_Pur_Order_API.Modify_From_Purchase (:requisition_no,                                                                         :line_no,                                                                         :release_no,                                                                         :order_no,                                                                         :assg_line_no,                                                                         :assg_release_no);                   END;';         -- ifs_assert_safe JaJalk 20060125         EXECUTE IMMEDIATE stmt_            USING IN requisition_no_,                  IN line_no_,                  IN release_no_,                  IN order_no_,                  IN assg_line_no_,                  IN assg_release_no_;

---------------------------------------------------------------------------------------------------------

 EXECUTE IMMEDIATE         'BEGIN            :activity_seq := active_separate_api.get_activity_seq(:wo_no);            :activity_state := Activity_API.Get_State(:activity_seq);            :activity_no := Activity_API.Get_Activity_No(:activity_seq);          END;'         USING         IN OUT activity_seq_,         IN wo_no_,         OUT activity_state_,         OUT activity_no_;