|
|
Browse by Tags
- 10.12.0.2 (Production)
- 10g
- 4.5
- 6i
- 9.0.4.0.19
- 9i
- Connecting to Oracle E-Business Suite Database
- data block populated based on record group
- document
- Error 201 at line 6 column 8 identifier 'PARTY_SERVICE_EXCEPTIONS' must be declared
- excel
- forms
- Forms 9.0.4 against 10.2 dbase
- Forms PL/SQL
- FRM-40212 Invalid value for field LAST_NAME
- FRM-40735
- FRM-92100: Your Connection to the Server was interrupted.
- How do I Trap FRM-40102: Record must be entered or deleted first error
- How to change key mapping on Oracle App Server
- IE
- IE 6.0
- open
- ORA-106561
- oracle
- Oracle Forms 10g
- pause
- PDE-PLI018 Could not find library Z:\fctlib.pll
- PL/SQL
- sleep
- trigger
- tutorial
- Unhandled Exception
- using cursor to populate data block
- web
- word
-
How do I Trap FRM-40102: Record must be entered or deleted first error
Whenever i click on Insert Record tool box button (Green Plus) I am getting FRM-40102: Record must be entered or deleted first error . How to trap this trap this error? IF errnum = 40102 THEN Clear_All; create_record; END IF; I want to put the above code. On which trigger i need to add this code.I have... -
data block populated based on record group
I would like to know how to dynamically associate a single form to a query in Oracle Forms. I have a drop-down box that lists table names. All tables are of the same format (4 columns). Based on the selected column, I would like to query to a different table and output the results to the same form. I... -
using cursor to populate data block
I'm trying to populate a data block dynamically based on the table selected by the user. My problemis that it doesn't accept the use of the variable :selected_table in my cursor definition : how can I make my query dynamic? Code Snippet: 1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16:... -
How to change key mapping on Oracle App Server
I am a developer trying to help my DBA to change the key mapping on our Oracle app server. He successfully changed the nls_language to UTF8, but that must have changed our default key mapping as enter-query/execute-query use to be F7/F8, now they are F11/ctrl-F11. We would like to get them changed back... -
Recalling already opened Oracle form
I have an Oracle forms application with multiple menus and many forms. Some forms are called from other forms. I have form C that can be called by both form A and form B. If form A calls form C, then the user opens form B (without backing out of either form C or A), and tries to call form C from form... -
Inserting multiple records
In my form, I have a data block which has a "where" clause that fetches multiple records, i.e. maximum 10 to a block and displays them. If I execute the command "Create Record" followed by "Duplicate Record", will it duplicate all the records which are fetched? So when I... -
How do I insert a pause in an Oracle Forms trigger?
I have a trigger in an Oracle Forms form. It emails multiple reminders based on a query. The first 39 or 40 do just fine; but then it quits emailing - almost like a buffer is full or something like that. I think if it would send an email, pause, send an email, pause, etc. that it would send them all... -
Form not inserting records properly. Oracle Error
I have a form which has three parts, a key block and two data blocks. The first data block is connected to a table called majors. The second data block is connected to a table called course. The relationship between majors and courses is one to many. Currently how it works is that I enter a set of values... -
Can't get LOV to populate the text item
I have created a record group and LOV for a text item on my form. When I execute the form and press F6, the LOV shows up with the list of values. However, when I select any of the items on the list, it does not copy it to the text item. What have I left out or doing incorrectly? -
Attaching LOV dynamically at runtime???
Is it possible to dynamically attach a LOV to text item at runtime.I think yes by SET_ITEM_PROPERTY. I have LOV1 and LOV2 .I want to attach LOV1 to a database item if form is in enter query mode else I want to attach LOV2.How can I achieve this?Please suggest what code and which trigger to use.Thanks...