ORA-02298 Parent Keys Not Found

After you export DB then import it you may get this error:

That means a value found in child table but not found in parent table.



You can solve it by the following script to get the values not found :



select <COLUMN_NAME> from <CHILD_TABLE> a where not exists (select <COLUMN_NAME> from



<PARENT_TABLE> where primary_key = a.<KEY_VALUE>);





To looks like :

Then you will get different values and insert them into parent table  or delete them from child table.

Thanks to Atlassian Documentation

Fixing Internet Explorer Crash on Launching Oracle Forms

here is simple video shows how to fix  Internet Explorer crash when running Forms.

replace jvm.dll file in the following path :

C:\Program Files (x86)\Oracle\JInitiator 1.3.1.22\bin\hotspot

you can download jvm file from here.

Using Aliases in same query

Alias is very helpful to shorten long query in SQL.



To use Alias in the same query you can use the following method:







SELECT  A,B,C*50 from (select A,B,(A+B) as C from table).



note that you can choose  any column from inner-query to display it in outer-query.



but you cannot display a column in outer-query which is not exist in inner-query.

You can try this example using SCOTT schema:



select  SAL,COMM,COMM_RATE *100 from (

select SAL,COMM,(COMM/SAL) as COMM_RATE from emp)

Remove the 'Do you want to save changes?' Messages in Forms

here is it ...

1. Modify the CLEAR_ALL_MASTER_DETAILS procedure body. Change the existing CLEAR_BLOCK(ASK_COMMIT) to CLEAR_BLOCK(DO_COMMIT).

2. Specifying NO_COMMIT or NO_VALIDATE with the CLEAR_BLOCK built-in causes

Oracle Forms to flush the current block without performing a commit or prompting the operator.

ex:CLEAR_BLOCK(NO_COMMIT,NO_VALIDATE);

Thanks to Dipankar...

Avoid FRM-40401 message

Use Standard.commit  instead of commit to prevent Oracle message :

Source :OraFAQ

Run Oracle forms from LAN

Assalamu Alikom,



I can not deny how does this work took time as I searched for it and made many tries between fails and success .



And here is the steps to run your Oracle project from any computer on the Local Network. 


Windows XP is recommened to install Application Server


1#Step : Install ORACLE DataBase 10g 




2#Step : Install ORACLE Developer 10g




After installation of Oracle developer :



goto C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN

then copy the files : 



listener.ora



sqlnet.ora



tnsnames.ora



and paste them to the following path :



C:\DevSuiteHome_1\NETWORK\ADMIN

3#Step : Install Application Server



download it from here ...



Be very careful before install and follow steps below :



1-download file staticports.conf   from here... and copy it to path  C:\oracle\FRHome_1\

2-Choose Manual install then choose the file staticports.conf





3-After install finishes write down the link appears to access Oracle Enterprise Manager, it looks like (http://localhost:7798)



4-goto C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN



then copy the files : 



listener.ora



sqlnet.ora



tnsnames.ora




and paste them to the following path :



C:\oracle\FRHome_1\NETWORK\ADMIN

5- Goto path C:\oracle\FRHome_1\\forms\server  where you installed app server

and make copy of file default.env  and paste it in the same place

6- Rename the new file to tr.env (you can rename it to any of yours)

7- Open file tr.env using  notepad

8-Edit the Form_path to FORMS_PATH=C:\DevsuiteHome_1\forms

Important: copy all your fmx  files of your project in the path (C:\FRHome_1\forms)

4#Step : Configure Application Server

1-Login Appserver  by typing Localhost in the address bar of any browser(internet explorer is preferred) or the link you wrote before

2-Choose Forms then  choose Configuration then choose Duplicate then choose New Section

and name it :EFL  (you can rename it to any of yours) then click OK

3-Choose Forms then  choose Configuration then select  EFL then click Edit

4- Edit the following items as followed:

baseHTMLjinitiator:basejini.htm

baseHTMLjpi:basejpi.htm

envFile:tr.env

form:login.fmx

userid:hr/hr@orcl

page Title:My First AppServer Application

then click Apply

5-Choose Forms  again and  copy the  link Servlet URL : http://localhost:7801/forms/frmservlt

6- edit the link to be http://localhost:7801/forms/frmservlt?config=EFL 

then paste it  in the browser and click Enter from keyboard

If you are on windows 7 then edit the baseHTMLjinitiator:basejpi.htm

6-Goto Oracle Enterprise Manager then choose PORTS  then select  WebCache     http

then click Edit icon

make it 80 then click OK  then it asks you Restart webcache? click Yes

be sure the Port:80 is not used by other programs on your PC

7-Open notepad then write the following code

You can get it from here :

https://drive.google.com/open?id=0B2PUacEN7OKGamgtTXluTmVFVTg


save file as rd.html

8- Paste rd.html  in the path C:\oracle\FRHome_1\Apache\Apache\htdocs

9-Goto Oracle Enterprise Manager then choose HTTP SERVER then Administration then Advanced server Properties  then  Httpd.conf

10- Search for DirectoryIndex then

make it DirectoryIndex rd.html

*OC4J  and Reports Server must be opened all time


5#Step : Running Forms over LAN

1-after running project on server   , we got the link like this:

http://localhost/forms/frmservlet?config=efl


2-replace localhost with server IP Address(you can get ip address  from Start then CMD then ipconfig then press enter)


it becomes 

http://192.168.1.4/forms/frmservlet?config=efl


3-From any computer connected to server over Local network  :

 install J initiator

goto   http://192.168.1.4/forms/frmservlet?config=efl


Update#1 : 

You can add multiple users with different Schemes by editing the file :

C:\oracle\FRHome_1\forms\server\formsweb.cfg 


you  just add in the end of file name , form path   and User credentials like  this :


[hr]

form=e:\hrm\Login.fmx



userid=hr/hr@orcl


Then the address to access this users forms is :

http://192.168.1.4/forms/frmservlet?config=hr


Update#2 : 

To display Arabic fonts  well , you must :


1#Replace uifont.ali  which is located in the following two paths :

C:\DevSuiteHome_1\tools\common

C:\oracle\FRHome_1\tools\common


2#Add Windows Fonts folder in Registry , It's found twice inside  Registry



Thanks to :

ميسم الكرام

Ahmed Elbanna

MS Server 2008 R2 Sounds

In the previous blog we talked about enabling Wireless in Microsoft server 2008 , here is the way to  enable the SOUNDS too.

Article was pick from HowToGeek web site.

All it takes to get sound functionality out of Server 2008 R2 is to set the Windows Audio service to start up automatically. To do this we need to open the Services MMC, the quickest way to do this is to press the Win + R key combination to bring up a run box, type services.msc and hit enter.

Once the Snap-In opens scroll down until you find the Windows Audio Service.

Double-click on it to open its properties.

Now you need to change the Startup drop-down box from Manual to Automatic.

Click ok when you are done, and restart your computer.

You should notice that your volume control icon went from looking like this

To this

You can now play music and movies through Windows Media Player which was installed in the first part of the series, or you could install a third party media player.

Source:HowToGeek