随笔分类 - Oracle EBS Form
摘要：The below plsql program unit could be used in a WHEN-NEW-FORM-INSTANCE trigger to initially populate the hierarchical tree with data in Oracle forms.DECLAREhtree ITEM;v_ignore NUMBER;rg_emps RECORDGRO...
阅读全文
摘要：You want to connect multiple databases in oracle forms to perform certain tasks, for example you need to execute ddl or dml statements against databases but when you try to use dblink it gives you err...
阅读全文
摘要：When called from an On-Fetch trigger, initiates the default Form Builder processing for fetching recordsthat have been identified by SELECT processing.FETCH_RECORDS examples/*** Built-in: FETCH_RECORD...
阅读全文
摘要：Suppose you want to scan a tabular grid block (loop through all records in detail block) from top to bottom in Oracle forms. You can do this task by using :system.last_record system variable to determ...
阅读全文
摘要：SYSTEM.CURSOR_BLOCK Determining current block in Oracle Forms Using SYSTEM.CURSOR_BLOCK system variable. The value that the SYSTEM.CURSOR_BLOCK system variable represents depends on the current navig...
阅读全文
摘要：I shared a data entry example form here in this post for Oracle Forms beginner developers, so that they may take an idea to how to develop a simple data entry form in Oracle Forms. The form can be ful...
阅读全文
摘要：A user-named trigger is a trigger defined in a form by the developer. User-Named triggers do not automatically fire in response to a Form Builder event, and must be called explicitly from other trigge...
阅读全文
摘要：Suppose you want to give the data backup option in Oracle Forms application to some client users, where you have installed Oracle 11g client or direct from server.The following procedure executes a ba...
阅读全文
摘要：Suppose you want to handle an error in oracle forms and want to display custom error message for that error, but also you want to customize more for a particular error. For example there are many fiel...
阅读全文
摘要：I wrote this trigger around 4 years ago to handle errors in an application based on Oracle Forms 6i. This trigger handles all errors with some custom messages for some specific errors and not only thi...
阅读全文
摘要：Oracle Form & Reports developer jobs are always in demand, candidates who have Oracle D2k, Oracle Forms & Reports, PLSQL set of skills can find the job through the following links: http://jobsearch....
阅读全文
摘要：A cursor acts logically as a pointer into a result set. You can move the cursor through the result set, processing each row, until you determine you are at the end of the result set. There are three t...
阅读全文
摘要：Suppose you want to populate a non-database data block with records manually in Oracle forms. This task can be done using a cursor. Below is the example given for hr.job_history table, where user in...
阅读全文
摘要：Suppose you want to read a file from D2k client and want to store its content in Oracle database. But if you will insert row by row from client to server it will take more time and increase lot of net...
阅读全文
摘要：Below is the example to read and import comma delimited csv file in oracle forms with D2k_Delimited_String package. This package is available in D2kdlstr.pll library.To download D2kdlstr.Pll Click Her...
阅读全文
摘要：The example given below for writing text file or CSV using Text_IO package from a tabular block in Oracle Forms. Suppose there is a tabular grid data block "Job_History" in your forms and you want...
阅读全文
摘要：Write Post-Query trigger for the block you want to fetch the field value for display item.ExampleBegin Select Ename into :datablock.dspname from emp where ecode = :datablock.ecode; -- Fi...
阅读全文
摘要：DISPLAY_ITEM built-in in Oracle D2k FormsDescriptionMaintained for backward compatibility only. For new applications, you should use theSET_ITEM_INSTANCE_PROPERTY built-in. DISPLAY_ITEM modifies an it...
阅读全文
摘要：When a query is open in the block, the Post-Query trigger fires each time Form Builder fetches a record into a block. The trigger fires once for each record placed on the block’s list of records. Usag...
阅读全文
摘要：See also: Why And When To Use Pre-Update and Pre-Insert Triggers In Oracle FormsPre-Update Fires during the Post and Commit Transactions process, before a row is updated in Oracle Forms. It fires once...
阅读全文
浙公网安备 33010602011771号