papalpha
asked on
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 to F7/F8. I do not have access to the app server but am trying to help him. I have requested that he:
1)Stop OC4J
2) Rename FRMWEB.RES TO FRMWEB_ORIG.RES,
3) COPY FRMPCWEB.RES TO FRMWEB.RES
4) Start OC4J
Which he claims he did and bounced the app server. The key mapping did not change. Then I requested that he use the following guidelines to make the change:
Modify the formsweb.cfg file with the command:
otherParams=term=fullpath\
where fullpath\filename.res would be /app/oracle/product/as10g/
Which he again claims he did, but the key mapping did not change.
Does anyone have any other suggestions as to what needs to be done to change the key mapping? We are using:
Forms [32 Bit] Version 10.1.2.0.2 (Production)
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining Scoring Engine options
Oracle Toolkit Version 10.1.2.0.2 (Production)
PL/SQL Version 10.1.0.4.2 (Production)
Oracle Procedure Builder V10.1.2.0.2 - Production
1)Stop OC4J
2) Rename FRMWEB.RES TO FRMWEB_ORIG.RES,
3) COPY FRMPCWEB.RES TO FRMWEB.RES
4) Start OC4J
Which he claims he did and bounced the app server. The key mapping did not change. Then I requested that he use the following guidelines to make the change:
Modify the formsweb.cfg file with the command:
otherParams=term=fullpath\
where fullpath\filename.res would be /app/oracle/product/as10g/
Which he again claims he did, but the key mapping did not change.
Does anyone have any other suggestions as to what needs to be done to change the key mapping? We are using:
Forms [32 Bit] Version 10.1.2.0.2 (Production)
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining Scoring Engine options
Oracle Toolkit Version 10.1.2.0.2 (Production)
PL/SQL Version 10.1.0.4.2 (Production)
Oracle Procedure Builder V10.1.2.0.2 - Production
ASKER
I finally got the blessing to connect to the app server manger and was able to use it to make the necessary changes. Thanks for your response.
please let me know the steps to do it.
I too desperately need the solution
I too desperately need the solution
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
A: Mapping F2
Change the default entry for F2, "List Tab Pages", to another key.
Here is an example of the default entry:
113: 0 : "F2" : 95 : "List Tab Pages"
This must be explicitly changed to another key mapping such as the following:
113: 8 : "F2" : 95 : "List Tab Pages"
To map the F2 function to the F2 key, comment out the lines that
begin with "113 : 0" and "113 : 8" with a # symbol and add the following lines
to the bottom of the resource file.
113: 0 : "F2" : 84 : "Function 2"
113: 8 : " " : 95 : " "
Explanation:
A new function has been added which uses F2 by default It is necessary to explicitly
map this new function to something else in order to map the F2 key." This function
was added to allow for keyboard navigation between the tab canvas pages and it
defaults to F2. Even if it is commented out and not assigned to F2, the F2 key
cannot be mapped unless this function, Forms Function Number 95, is mapped to
another key.