Oracle Forms Designer has stopped working/ How to apply Patchset 7047034 ?

As salamualikum Readers,

When you install Oracle Developer Suite 10g Release 2 on windows 7 and try to open any form within the builder, you may face the following issues..

Oracle Forms Designer Has stopped Working

Windows can check online for a solution to the problem.

---> Check online for a solution and close the program
----> close the program

What is the solution ?

There is two solution for this issue.

Solution # 1

1. Open form builder.
2.  Make connection with database.
3.  Now open the form.

If solution # 1 doesn't work in your case then your need metalink (support.oracle.com) access which required valid support account.

 Solution #2

1. Download Patchset no. 7047034
2. Extract in root drive like C:\ 7047034
3. open command prompt with admin previlage (@ write cmd)
4. set oracle_home like (C:\Users\Administrator>set oracle_home=C:\DevSuiteHome_1)
5. set PATH=%ORACLE_HOME%\OPatch;%PATH% like (C:\Users\Administrator>set PATH=%ORACLE_HOME%\OPatch;%PATH%)
6. go to patchset folder like (C:\Users\Administrator>cd c:\7047034)
7. write opatch apply like (c:\7047034>opatch apply)

8. When your see >>Is this system ready for updating?
   Please respond Y|N > << Type Y and press Enter Key

9. at finishing you will see >>OPatch succeeded.
   OPatch returns with error code = 0 <<

10. write cscript //nologo remove_demo.js like (c:\7047034>cscript //nologo remove_demo.js)

Your are done. ;)

Now open form builder and open any form without error.

Enjoy Oracle Forms Developing..

If it helps, Leave your message.

How to Add or Remove List Text Anywhere from List Item?

Dear Mates,
Hope your are fine. Here we will talk a trick of Oracle List Item for Forms Version 10g and 6i.

If you want to remove list text and values from a oracle forms list item. How will you do this ? When there is no remove icons and Backspace and Delete key doesn't work, both just lest blank spaces.

Don't worry. I'm here for your help. Try the following shortcut key..

"Ctrl + Shift + >" - add list element.

"Ctrl + Shift + <" - remove list element.

Leave comment and SMILTE :)

How to Check Only One Item In a Check Box ?

Hello Redars, How are you ?

Here i will share a tricky PL/SQL code with you. If you want to use Check Box in oracle forms and want to restrict end user to select only one check box, how will you handle this ?

Just customize the following code and you will get the result.

declare
  l_current_record number;
  l_last_record    number;
begin
  l_current_record := :system.trigger_record;

  last_record;
  l_last_record := :system.cursor_record;
 
  first_record;
   
  for i in 1 .. l_last_record loop
    if :system.cursor_record <> l_current_record then
       :SM_ACT_FLAG := 0;
    end if;
    next_record;
  end loop;
 
  go_record(l_current_record);
end;

If you have any question regarding this..just leave comments and i will answer.