61. error_code; 捕获并且显示oracle forms的错误序号 62. error_text; 显示解释form错误的文字信息 63. error_type; 显示错误的类型.frm说明forms错误,ora说明是数据库错误 64. execute_query 使oracle提取记录到form中,并置form于更新模式 65. execute_trigger(触发器名) 执行指定的触发器 66. fetch_records;...
This document lists the order in which triggers fire in Oracle Forms 4.5: o The first column, Action, describes the function to be performed (e.g. deleting a record). o The second column, Trigger Firing Order, describes the order in which triggers fire after a function is performed. o ...
Triggers are blocks of PL/SQL code that are written to perform tasks when a specific event occurs within an application. In effect, an Oracle Forms trigger is an event-handler written in PL/SQL to augment (or occasionally replace) the default processing behavior. Every trigger has a name, ...
This document lists the order in which triggers fire in Oracle Forms 4.5: o The first column, Action, describes the function to be performed (e.g. deleting a record). o The second column, Trigger Firing Order, describes the order in which triggers fire after a function is performed. o ...
61.error_code; 捕获并且显示oracle forms的错误序号 62.error_text; 显示解释form错误的文字信息 63.error_type; 显示错误的类型.frm说明forms错误,ora说明是数据库错误 64.execute_query 使oracle提取记录到form中,并置form于更新模式 65.execute_trigger(触发器名) 执行指定的触发器 ...
Form的Trigger的优先级是从item,到block,到form级别,如果另外设置Execution Hierarch属性(override,before,after),则按照设置后的顺序执行。如果是override的话,则执行完这个级别的触发器,就不往上执行了,before就是执行完这个级别的触发器后,如果上一个级别也有这个触发器的话,继续去执行,after就是先去执行上一个级别...
EXECUTE_TRIGGER EXIT_FORM FIND_FORM FORM_FAILURE FORM_FATAL FORM_SUCCESS GET_FORM_PROPERTY GO_FORM HELP NEW_FORM NEXT_FORM OPEN_FORM POST PREVIOUS_FORM REDISPLAY REPLACE_MENU SET_FORM_PROPERTY SHOW_KEYS SHOW_MENU SYNCHRONIZE 2.4 块内置子程序 ...
public void sendMessageToForms(String event, String payload) { try { // set properties to pass to Oracle Forms mHandler.setProperty(PROP_EVENT, event); mHandler.setProperty(PROP_PAYLOAD, payload); // trigger WHEN-CUSTOM-ITEM-EVENT trigger in Forms ...
Block 的delete_allowed属性设置为Y,DML data source type设置为无,这样删除按钮会亮,但不能删除记录,点删除按钮时下面会提示需要ON-LOCK trigger。 12.如果在post-query中用select into为某个item赋值,此item的database item属性需设置为No,否则在ctrl+f11查询后后会有提示框 ...
document.forms_applet.raiseEvent(event_name, payload); The assumption here is that you have set the ID configuration variable toforms_applet. When the surrounding Web page executes this JavaScript code, Oracle Forms fires a new type of trigger calledWHEN-CUSTOM-JAVASCRIPT-EVENT. In this trigger ...