摘要:
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... 阅读全文
posted @ 2016-12-25 21:29
全威儒
阅读(472)
评论(0)
推荐(0)
摘要:
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... 阅读全文
posted @ 2016-12-25 21:27
全威儒
阅读(516)
评论(0)
推荐(0)
摘要:
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... 阅读全文
posted @ 2016-12-25 21:23
全威儒
阅读(264)
评论(0)
推荐(0)
摘要:
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... 阅读全文
posted @ 2016-12-25 21:21
全威儒
阅读(1447)
评论(0)
推荐(0)
摘要:
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... 阅读全文
posted @ 2016-12-25 21:19
全威儒
阅读(390)
评论(0)
推荐(0)
摘要:
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... 阅读全文
posted @ 2016-12-25 21:17
全威儒
阅读(190)
评论(0)
推荐(0)
摘要:
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... 阅读全文
posted @ 2016-12-25 21:15
全威儒
阅读(213)
评论(0)
推荐(0)
摘要:
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... 阅读全文
posted @ 2016-12-25 21:12
全威儒
阅读(332)
评论(0)
推荐(0)
摘要:
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... 阅读全文
posted @ 2016-12-25 21:11
全威儒
阅读(878)
评论(0)
推荐(0)
摘要:
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.... 阅读全文
posted @ 2016-12-25 20:14
全威儒
阅读(218)
评论(0)
推荐(0)