Oracle Developer 10g 10.1.2.0.2 Crash on Windows 7 while opening forms modules!

May 21, 2011

We are using Oracle developer 10g, details:

Forms [32 Bit] Version 10.1.2.0.2 (Production)
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – 64bit Production
With the Partitioning, OLAP and Data Mining 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
PL/SQL Editor (c) WinMain Software (www.winmain.com), v1.0 (Production)
Oracle Query Builder 10.1.2.0.2 – Production
Oracle Virtual Graphics System Version 10.1.2.0.2 (Production)
Oracle Tools GUI Utilities Version 10.1.2.0.2 (Production)
Oracle Multimedia Version 10.1.2.0.2 (Production)
Oracle Tools Integration Version 10.1.2.0.2 (Production)
Oracle Tools Common Area Version 10.1.2.0.2
Oracle CORE 10.1.0.4.0 Production

and recently noticed additional crashing behavior on Windows 7 (64Bit) without any apparent reasons. Based on one of our previous posts, after dwelling into possible reasons figured out the following!

Few of the database level procedures were modified with more parameters(IN and OUT) which was causing the developer suite to crash down.

So, prior you make changes to database level procedures or functions, MAKE SURE YOU DO CHANGE THE PROCEDURE/FUNCTION CALLS FROM YOUR FORM MODULES with all new IN and OUT parameters, then proceed with compiling your Procedures and Functions @ database level. If anybody is aware of another method to deal with this situation, please pass the information through comments.

for Windows7bugs,

Admin

Advertisements

Testing Oracle 10g developer forms locally (On Windows 7)

March 27, 2011

Okay guys, another post after another break :) This time we are going to figure out how to test your Oracle 10g developer forms locally. Until recent comments we were not knowing that fellow folks were having issues running developer 10g forms locally on Windows 7 machines. Okay here we go
Step 1
Install the latest java run time from here and make sure you are installing 32bit. Usually java 32bit gets installed under this path “C:\Program Files (x86)\Java\jre6”
Following is test environment

OS: Windows 7 64bit Professional Editions, 3GB Mem
10g Developer: Forms [32 Bit] Version 10.1.2.0.2 (Production)
Database: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production

Usually when you try to run a form locally for the first time after starting the OC4J instance, an older version of java initiator is installed in your system. I don’t quite remember whether the installation offers any kind of customization so that the end user could change the path or other options. I won’t recommend one either!
If you have done a standard installation, the java initiator should get installed on this path “C:\Program Files (x86)\Oracle\JInitiator 1.3.1.22”.

Step 2

In order to let Developer 10g forms run locally you need to change the jvm.dll file found under “C:\Program Files (x86)\Oracle\JInitiator 1.3.1.22\bin\hotspot” with a most recent one. As we installed the latest java run time 32bit in “Step 1”, browse to the following folder “C:\Program Files (x86)\Java\jre6\bin\client” copy the jvm.dll which is above 2MB in size, and go back to folder “C:\Program Files (x86)\Oracle\JInitiator 1.3.1.22\bin\hotspot”

Now paste the new jvm.dll file inside this folder and try to run the forms again! It should work now!