FUNCTION FND_CONCURRENT.WAIT_FOR_REQUEST
来源:互联网 发布:java设计培训中心 编辑:程序博客网 时间:2024/06/03 21:09
====================
The following describes how to submit concurrent requests using PL/SQL and
have the parent request 'wait' until each of the child processes have
completed before it completes.
Search Words: WAIT_FOR_REQUEST phase status arguments interval
Solution Description:
=====================
When submitting concurrent requests using PL/SQL, it is often desired to have
the parent process wait until all the child processes have completed before
completing itself. The following describes the function used to accomplish
this.
Use the FND_CONCURRENT.WAIT_FOR_REQUEST function documented in the Oracle
Applications Developer’s Guide, RELEASE 11i, Page 21-8 See the FND_CONCURRENT.WAIT_FOR_REQUEST
function description.
Summary
FUNCTION FND_CONCURRENT.WAIT_FOR_REQUEST
(request_id IN number default NULL,
interval IN number default 60,
max_wait IN number default 0,
phase OUT varchar2,
status OUT varchar2,
dev_phase OUT varchar2,
dev_status OUT varchar2,
message OUT varchar2) return boolean;
Description
Wait for the request completion, then return the request phase/status and
completion message to the caller. Also call sleep between database checks.
Arguments (input)
request_id
The request ID of the program to wait on.
interval
Time to wait between checks. This is the number of seconds to sleep.
The default is 60 seconds.
max_wait
The maximum time in seconds to wait for the requests completion.
Arguments (output)
phase
The user friendly request phase from FND_LOOKUPS.
status
The user friendly request status from FND_LOOKUPS.
dev_phase
The request phase as a constant string that can be used for program
logic comparisons.
dev_status
The request status as a constant string that can be used for program
logic comparisons.
message
The completion message supplied if the request has completed.
语法:
FUNCTION fnd_concurrent.wait_for_request(request_id IN NUMBER DEFAULT NULL,
INTERVAL IN NUMBER DEFAULT 60,
max_wait IN NUMBER DEFAULT 0,
phase OUT VARCHAR2,
status OUT VARCHAR2,
dev_phase OUT VARCHAR2,
dev_status OUT VARCHAR2,
message OUT VARCHAR2) RETURN BOOLEAN;
说明:等待并发请求的完成,然后返回请求的阶段、状态以及完成消息。在等待的过程中每隔一段时间检查一下。
输入参数说明:
request_id: 并发请求的id
interval: 两次检查见等待的秒数,两次检查之间该程序会休息
max_wait: 等待并发请求完成所能等待的的最长时间,单位为秒。
输出参数同前一个函数,恕罗勇不重复翻译啦。
原文没有示例用法,罗勇补充个:
DECLARE
call_status BOOLEAN;
rphase VARCHAR2(80);
rstatus VARCHAR2(80);
dphase VARCHAR2(30);
dstatus VARCHAR2(30);
message VARCHAR2(240);
request_id NUMBER;
BEGIN
request_id := 3046222;
call_status := fnd_concurrent.wait_for_request(request_id,
10,
1000,
rphase,
rstatus,
dphase,
dstatus,
message);
IF call_status THEN
dbms_output.put_line(rphase || '|' || rstatus || '|' || message);
END IF;
END;
程序会等在此处直到并发请求完成或者满了1000秒。
- FUNCTION FND_CONCURRENT.WAIT_FOR_REQUEST
- fnd_concurrent.wait_for_request
- 提交并发请求时使用FUNCTION FND_CONCURRENT.WAIT_FOR_REQUEST等待子并发程序完成
- 关于FND_REQUEST.SUBMIT_REQUEST和 FND_CONCURRENT.WAIT_FOR_REQUEST
- 关于FND_REQUEST.SUBMIT_REQUEST和 FND_CONCURRENT.WAIT_FOR_REQUEST
- 关于FND_REQUEST.SUBMIT_REQUEST和 FND_CONCURRENT.WAIT_FOR_REQUEST
- Oracle EBS的FND_CONCURRENT.WAIT_FOR_REQUEST卡住的问题
- ORACLE ERP中 关于FND_REQUEST.SUBMIT_REQUEST和 FND_CONCURRENT.WAIT_FOR_REQUEST 的介绍与用法
- Oracle Form中调用并发请求生成报表并输出为PDF的方法 (FND_CONCURRENT.WAIT_FOR_REQUEST)
- wait_for_request的作用
- Oracle EBS fnd_request.submit_request 与 Fnd_concurrent.wait_for_ruqest
- Function
- function
- function
- function $()
- Function
- function
- Function
- STM32不完全手册学习笔记--GPIO
- winform通用分页控件
- BOM导入及更新
- IOS Block 并发
- 百度网盘邀请链接
- FUNCTION FND_CONCURRENT.WAIT_FOR_REQUEST
- 重构36计(2)
- 如何做好英文外贸B2C网站的优化
- 指针与引用的区别
- Objective-C 之类目(category)的应用
- 金融常识总结五
- 如何删除桌面的回收站图标
- EBS fnd_global.apps_initialize的使用详解 .
- Sqlmap的POST注入