Sunday, January 27, 2013

How to Get Number of Days In a Year ?

If you cannot calculate how many days in a year, here is an easy example for you. Write down the bellow code directly in sql*plus or SQL Developer or any others tools and get the result. :)

SELECT ADD_MONTHS(TRUNC(SYSDATE,'RRRR'),12)-TRUNC(SYSDATE,'RRRR')
FROM DUAL;
Hope it helps...

If any query, just leave your comments...

Wednesday, January 23, 2013

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.