Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

re-write 6i code in 11g forms

Posted on 2015-01-30
5
Medium Priority
?
144 Views
Last Modified: 2015-02-06
hi how can i re-write this code in 11gR2 as set_input_focus is absolute
procedure PROC_FLD is
BEGIN
  if name_in('system.current_field') = 'SCR_NOHLP_FIRST_FIELD' then
     set_input_focus (menu);
  end if;
END;

Open in new window

0
Comment
Question by:chalie001
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 35

Expert Comment

by:johnsone
ID: 40579698
I managed to find a copy of the Forms 6i documentation here -> http://download.oracle.com/otn_hosted_doc/forms/forms/A73074_01.pdf

According to that documentation:

/*
** Built-in: SET_INPUT_FOCUS
** Example: Directs the users input focus to the Menu when
** used with the only support parameter, MENU.
** Only has an effect on character-mode or
** block-mode devices.
*/

As this is cross posted in web development and java areas, I'm guessing your forms are not being run in character mode.  I believe that you can just remove the call to the function without changing functionality.

That is backed up by the last comment in this post -> https://community.oracle.com/thread/943276
0
 
LVL 22

Expert Comment

by:Helena Marková
ID: 40583402
As an addition to johnsone's answer you can also use Migration Assistant - frmplsqlconv.bat (it is a part of Forms installation).
0
 

Author Comment

by:chalie001
ID: 40583708
i did i replace it with null but how can i replace as it is absolute and how can  i do batch compile of library and forms
0
 

Author Comment

by:chalie001
ID: 40583994
am geting this error when i run migration assistance
Log written into File - C:\MigrationLog\logliib20922
processing ....
Log - C:\migrationform\CALMAIN.FMB touched : Mon Feb 02 14:55:46 CAT 2015
ERROR opening C:\migrationform\CALMAIN.FMB :oracle.forms.jdapi.JdapiException: FRM-10102: Cannot attach PL/SQL library LSPL_SET_LOV_VALID_USER_UNIT. This library attachment will be lost if the module is saved.
FRM-10102: Cannot attach PL/SQL library LGNL0001. This library attachment will be lost if the module is saved.
Check subclass and library dependencies
Log - C:\migrationform\CALMAIN.FMB released : Mon Feb 02 14:55:47 CAT 2015


------------------------------------------------------------
[End of Log]
0
 
LVL 22

Accepted Solution

by:
Helena Marková earned 2000 total points
ID: 40585602
There is problem with path there. One option is putting all libraries to the directory where *.fmb are located.
0

Featured Post

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
This theoretical tutorial explains exceptions, reasons for exceptions, different categories of exception and exception hierarchy.
Suggested Courses

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question