Oracle Form freezes after configure WEBUTIL

1

I am using oracle forms 10g. It is web based oracle form application. I want to generate Excel Report from Oracle Forms 10g. I configured WEBUTIL and use CLIENT_OLE2 package. Procedure declared in trigger WHEN-BUTTON-PRESSED. When button pressed then suddenly the form freezes and they cannot do anything. Exit button and menu options stops working. It does not give any message and does not do any action also.

Procedure Code:

declare

 application client_ole2.obj_type;

 workbooks client_ole2.obj_type;

 workbook client_ole2.obj_type;

 worksheets client_ole2.obj_type;

 worksheet client_ole2.obj_type;

 cell client_ole2.obj_type;

 arglist client_ole2.list_type;

 row_num number;

 col_num number;

 fontObj client_ole2.obj_type;



cursor rec is SELECT so.descr saleorgdescr,ih.invdate invdatemaster, ih.docNUM docnum,

   TO_CHAR(ih.invdate,'mon-yyyy') invmonth

FROM ARMINVHEAD ih, SDMSALEORG so

WHERE

ih.status='69'

AND  TO_DATE(ih.INVDATE,'DD-MM-RRRR')

BETWEEN

                   TO_DATE('01-01-2008','DD-MM-RRRR') 

              AND  

                   TO_DATE('01-01-2009','DD-MM-RRRR')

order by IH.INVDATE, ih.docnum;



procedure SetCellValue(rowid number,colid number,cellValue varchar) is

 begin

 arglist := client_ole2.create_arglist;

 client_ole2.add_arg(arglist,rowid);

 client_ole2.add_arg(arglist,colid);

 cell:= client_ole2.get_obj_property(worksheet,'Cells',arglist);

 fontObj := client_ole2.get_obj_property(cell,'Font');

 client_ole2.destroy_arglist(arglist);

 client_ole2.set_property(cell,'value',cellValue);

 client_ole2.set_property(fontObj,'Size',16);

 client_ole2.set_property(fontObj,'BOLD',1);

 client_ole2.set_property(fontObj,'ColorIndex',7);

 client_ole2.release_obj(cell);

end SetCellValue;



procedure app_init is

 begin

 application := client_ole2.create_obj('Excel.Application');

 client_ole2.set_property(application,'Visible',true);

 workbooks := client_ole2.get_obj_property(application,'workbooks');

 workbook := client_ole2.Get_Obj_Property(workbooks,'add');

 worksheets := client_ole2.get_obj_property(application,'worksheets');

 worksheet := client_ole2.Get_Obj_Property(worksheets,'add');

 client_ole2.set_property(worksheet,'Name','Emp Sheet');

end app_init;



procedure save_excel(path varchar,filename varchar) is

 begin

 client_OLE2.Release_Obj(worksheet);

 client_OLE2.Release_Obj(worksheets);

 -- Save the Excel file created

 If path is not null then

   Arglist := client_OLE2.Create_Arglist;

   client_OLE2.Add_Arg(Arglist,path||''||file_name||'.xls');

   client_OLE2.Invoke(workbook, 'SaveAs', Arglist);

   client_OLE2.Destroy_Arglist(Arglist);

end if;

end save_excel;



begin

 app_init;

 row_num:=1;

 col_num:=1;

 SetCellValue(row_num,col_num,'saleorgdescr');

 col_num:=col_num + 1;

 SetCellValue(row_num,col_num,'invdatemaster');

 col_num:=col_num + 1;

 SetCellValue(row_num,col_num,'docnum');

 col_num:=col_num + 1;

 SetCellValue(row_num,col_num,'invmonth');

 for i in rec loop

 row_num:=row_num + 1;

 col_num:=1;

 SetCellValue(row_num,col_num,i.saleorgdescr);    

 col_num:=2;

 SetCellValue(row_num,col_num,i.invdatemaster);    

 col_num:=3;

 SetCellValue(row_num,col_num,i.docnum);

 col_num:=4;

 SetCellValue(row_num,col_num,i.invmonth);   

end loop;    

save_excel('C:','emp_data');       

client_OLE2.Release_Obj(workbook);

client_OLE2.Release_Obj(workbooks);

client_OLE2.Release_Obj(application);

end;

oracle oracle10g oracleforms oracle-fusion-middleware

share|improve this question

asked Nov 23 '18 at 11:33

Ammad WasimAmmad Wasim

236

add a comment | 

1

I am using oracle forms 10g. It is web based oracle form application. I want to generate Excel Report from Oracle Forms 10g. I configured WEBUTIL and use CLIENT_OLE2 package. Procedure declared in trigger WHEN-BUTTON-PRESSED. When button pressed then suddenly the form freezes and they cannot do anything. Exit button and menu options stops working. It does not give any message and does not do any action also.

Procedure Code:

declare

 application client_ole2.obj_type;

 workbooks client_ole2.obj_type;

 workbook client_ole2.obj_type;

 worksheets client_ole2.obj_type;

 worksheet client_ole2.obj_type;

 cell client_ole2.obj_type;

 arglist client_ole2.list_type;

 row_num number;

 col_num number;

 fontObj client_ole2.obj_type;



cursor rec is SELECT so.descr saleorgdescr,ih.invdate invdatemaster, ih.docNUM docnum,

   TO_CHAR(ih.invdate,'mon-yyyy') invmonth

FROM ARMINVHEAD ih, SDMSALEORG so

WHERE

ih.status='69'

AND  TO_DATE(ih.INVDATE,'DD-MM-RRRR')

BETWEEN

                   TO_DATE('01-01-2008','DD-MM-RRRR') 

              AND  

                   TO_DATE('01-01-2009','DD-MM-RRRR')

order by IH.INVDATE, ih.docnum;



procedure SetCellValue(rowid number,colid number,cellValue varchar) is

 begin

 arglist := client_ole2.create_arglist;

 client_ole2.add_arg(arglist,rowid);

 client_ole2.add_arg(arglist,colid);

 cell:= client_ole2.get_obj_property(worksheet,'Cells',arglist);

 fontObj := client_ole2.get_obj_property(cell,'Font');

 client_ole2.destroy_arglist(arglist);

 client_ole2.set_property(cell,'value',cellValue);

 client_ole2.set_property(fontObj,'Size',16);

 client_ole2.set_property(fontObj,'BOLD',1);

 client_ole2.set_property(fontObj,'ColorIndex',7);

 client_ole2.release_obj(cell);

end SetCellValue;



procedure app_init is

 begin

 application := client_ole2.create_obj('Excel.Application');

 client_ole2.set_property(application,'Visible',true);

 workbooks := client_ole2.get_obj_property(application,'workbooks');

 workbook := client_ole2.Get_Obj_Property(workbooks,'add');

 worksheets := client_ole2.get_obj_property(application,'worksheets');

 worksheet := client_ole2.Get_Obj_Property(worksheets,'add');

 client_ole2.set_property(worksheet,'Name','Emp Sheet');

end app_init;



procedure save_excel(path varchar,filename varchar) is

 begin

 client_OLE2.Release_Obj(worksheet);

 client_OLE2.Release_Obj(worksheets);

 -- Save the Excel file created

 If path is not null then

   Arglist := client_OLE2.Create_Arglist;

   client_OLE2.Add_Arg(Arglist,path||''||file_name||'.xls');

   client_OLE2.Invoke(workbook, 'SaveAs', Arglist);

   client_OLE2.Destroy_Arglist(Arglist);

end if;

end save_excel;



begin

 app_init;

 row_num:=1;

 col_num:=1;

 SetCellValue(row_num,col_num,'saleorgdescr');

 col_num:=col_num + 1;

 SetCellValue(row_num,col_num,'invdatemaster');

 col_num:=col_num + 1;

 SetCellValue(row_num,col_num,'docnum');

 col_num:=col_num + 1;

 SetCellValue(row_num,col_num,'invmonth');

 for i in rec loop

 row_num:=row_num + 1;

 col_num:=1;

 SetCellValue(row_num,col_num,i.saleorgdescr);    

 col_num:=2;

 SetCellValue(row_num,col_num,i.invdatemaster);    

 col_num:=3;

 SetCellValue(row_num,col_num,i.docnum);

 col_num:=4;

 SetCellValue(row_num,col_num,i.invmonth);   

end loop;    

save_excel('C:','emp_data');       

client_OLE2.Release_Obj(workbook);

client_OLE2.Release_Obj(workbooks);

client_OLE2.Release_Obj(application);

end;

oracle oracle10g oracleforms oracle-fusion-middleware

share|improve this question

asked Nov 23 '18 at 11:33

Ammad WasimAmmad Wasim

236

add a comment | 

1

1

1

I am using oracle forms 10g. It is web based oracle form application. I want to generate Excel Report from Oracle Forms 10g. I configured WEBUTIL and use CLIENT_OLE2 package. Procedure declared in trigger WHEN-BUTTON-PRESSED. When button pressed then suddenly the form freezes and they cannot do anything. Exit button and menu options stops working. It does not give any message and does not do any action also.

Procedure Code:

declare

 application client_ole2.obj_type;

 workbooks client_ole2.obj_type;

 workbook client_ole2.obj_type;

 worksheets client_ole2.obj_type;

 worksheet client_ole2.obj_type;

 cell client_ole2.obj_type;

 arglist client_ole2.list_type;

 row_num number;

 col_num number;

 fontObj client_ole2.obj_type;



cursor rec is SELECT so.descr saleorgdescr,ih.invdate invdatemaster, ih.docNUM docnum,

   TO_CHAR(ih.invdate,'mon-yyyy') invmonth

FROM ARMINVHEAD ih, SDMSALEORG so

WHERE

ih.status='69'

AND  TO_DATE(ih.INVDATE,'DD-MM-RRRR')

BETWEEN

                   TO_DATE('01-01-2008','DD-MM-RRRR') 

              AND  

                   TO_DATE('01-01-2009','DD-MM-RRRR')

order by IH.INVDATE, ih.docnum;



procedure SetCellValue(rowid number,colid number,cellValue varchar) is

 begin

 arglist := client_ole2.create_arglist;

 client_ole2.add_arg(arglist,rowid);

 client_ole2.add_arg(arglist,colid);

 cell:= client_ole2.get_obj_property(worksheet,'Cells',arglist);

 fontObj := client_ole2.get_obj_property(cell,'Font');

 client_ole2.destroy_arglist(arglist);

 client_ole2.set_property(cell,'value',cellValue);

 client_ole2.set_property(fontObj,'Size',16);

 client_ole2.set_property(fontObj,'BOLD',1);

 client_ole2.set_property(fontObj,'ColorIndex',7);

 client_ole2.release_obj(cell);

end SetCellValue;



procedure app_init is

 begin

 application := client_ole2.create_obj('Excel.Application');

 client_ole2.set_property(application,'Visible',true);

 workbooks := client_ole2.get_obj_property(application,'workbooks');

 workbook := client_ole2.Get_Obj_Property(workbooks,'add');

 worksheets := client_ole2.get_obj_property(application,'worksheets');

 worksheet := client_ole2.Get_Obj_Property(worksheets,'add');

 client_ole2.set_property(worksheet,'Name','Emp Sheet');

end app_init;



procedure save_excel(path varchar,filename varchar) is

 begin

 client_OLE2.Release_Obj(worksheet);

 client_OLE2.Release_Obj(worksheets);

 -- Save the Excel file created

 If path is not null then

   Arglist := client_OLE2.Create_Arglist;

   client_OLE2.Add_Arg(Arglist,path||''||file_name||'.xls');

   client_OLE2.Invoke(workbook, 'SaveAs', Arglist);

   client_OLE2.Destroy_Arglist(Arglist);

end if;

end save_excel;



begin

 app_init;

 row_num:=1;

 col_num:=1;

 SetCellValue(row_num,col_num,'saleorgdescr');

 col_num:=col_num + 1;

 SetCellValue(row_num,col_num,'invdatemaster');

 col_num:=col_num + 1;

 SetCellValue(row_num,col_num,'docnum');

 col_num:=col_num + 1;

 SetCellValue(row_num,col_num,'invmonth');

 for i in rec loop

 row_num:=row_num + 1;

 col_num:=1;

 SetCellValue(row_num,col_num,i.saleorgdescr);    

 col_num:=2;

 SetCellValue(row_num,col_num,i.invdatemaster);    

 col_num:=3;

 SetCellValue(row_num,col_num,i.docnum);

 col_num:=4;

 SetCellValue(row_num,col_num,i.invmonth);   

end loop;    

save_excel('C:','emp_data');       

client_OLE2.Release_Obj(workbook);

client_OLE2.Release_Obj(workbooks);

client_OLE2.Release_Obj(application);

end;

oracle oracle10g oracleforms oracle-fusion-middleware

share|improve this question

asked Nov 23 '18 at 11:33

Ammad WasimAmmad Wasim

236

I am using oracle forms 10g. It is web based oracle form application. I want to generate Excel Report from Oracle Forms 10g. I configured WEBUTIL and use CLIENT_OLE2 package. Procedure declared in trigger WHEN-BUTTON-PRESSED. When button pressed then suddenly the form freezes and they cannot do anything. Exit button and menu options stops working. It does not give any message and does not do any action also.

Procedure Code:

declare

 application client_ole2.obj_type;

 workbooks client_ole2.obj_type;

 workbook client_ole2.obj_type;

 worksheets client_ole2.obj_type;

 worksheet client_ole2.obj_type;

 cell client_ole2.obj_type;

 arglist client_ole2.list_type;

 row_num number;

 col_num number;

 fontObj client_ole2.obj_type;



cursor rec is SELECT so.descr saleorgdescr,ih.invdate invdatemaster, ih.docNUM docnum,

   TO_CHAR(ih.invdate,'mon-yyyy') invmonth

FROM ARMINVHEAD ih, SDMSALEORG so

WHERE

ih.status='69'

AND  TO_DATE(ih.INVDATE,'DD-MM-RRRR')

BETWEEN

                   TO_DATE('01-01-2008','DD-MM-RRRR') 

              AND  

                   TO_DATE('01-01-2009','DD-MM-RRRR')

order by IH.INVDATE, ih.docnum;



procedure SetCellValue(rowid number,colid number,cellValue varchar) is

 begin

 arglist := client_ole2.create_arglist;

 client_ole2.add_arg(arglist,rowid);

 client_ole2.add_arg(arglist,colid);

 cell:= client_ole2.get_obj_property(worksheet,'Cells',arglist);

 fontObj := client_ole2.get_obj_property(cell,'Font');

 client_ole2.destroy_arglist(arglist);

 client_ole2.set_property(cell,'value',cellValue);

 client_ole2.set_property(fontObj,'Size',16);

 client_ole2.set_property(fontObj,'BOLD',1);

 client_ole2.set_property(fontObj,'ColorIndex',7);

 client_ole2.release_obj(cell);

end SetCellValue;



procedure app_init is

 begin

 application := client_ole2.create_obj('Excel.Application');

 client_ole2.set_property(application,'Visible',true);

 workbooks := client_ole2.get_obj_property(application,'workbooks');

 workbook := client_ole2.Get_Obj_Property(workbooks,'add');

 worksheets := client_ole2.get_obj_property(application,'worksheets');

 worksheet := client_ole2.Get_Obj_Property(worksheets,'add');

 client_ole2.set_property(worksheet,'Name','Emp Sheet');

end app_init;



procedure save_excel(path varchar,filename varchar) is

 begin

 client_OLE2.Release_Obj(worksheet);

 client_OLE2.Release_Obj(worksheets);

 -- Save the Excel file created

 If path is not null then

   Arglist := client_OLE2.Create_Arglist;

   client_OLE2.Add_Arg(Arglist,path||''||file_name||'.xls');

   client_OLE2.Invoke(workbook, 'SaveAs', Arglist);

   client_OLE2.Destroy_Arglist(Arglist);

end if;

end save_excel;



begin

 app_init;

 row_num:=1;

 col_num:=1;

 SetCellValue(row_num,col_num,'saleorgdescr');

 col_num:=col_num + 1;

 SetCellValue(row_num,col_num,'invdatemaster');

 col_num:=col_num + 1;

 SetCellValue(row_num,col_num,'docnum');

 col_num:=col_num + 1;

 SetCellValue(row_num,col_num,'invmonth');

 for i in rec loop

 row_num:=row_num + 1;

 col_num:=1;

 SetCellValue(row_num,col_num,i.saleorgdescr);    

 col_num:=2;

 SetCellValue(row_num,col_num,i.invdatemaster);    

 col_num:=3;

 SetCellValue(row_num,col_num,i.docnum);

 col_num:=4;

 SetCellValue(row_num,col_num,i.invmonth);   

end loop;    

save_excel('C:','emp_data');       

client_OLE2.Release_Obj(workbook);

client_OLE2.Release_Obj(workbooks);

client_OLE2.Release_Obj(application);

end;

oracle oracle10g oracleforms oracle-fusion-middleware

oracle oracle10g oracleforms oracle-fusion-middleware

share|improve this question

asked Nov 23 '18 at 11:33

Ammad WasimAmmad Wasim

236

share|improve this question

asked Nov 23 '18 at 11:33

Ammad WasimAmmad Wasim

236

share|improve this question

share|improve this question

asked Nov 23 '18 at 11:33

Ammad WasimAmmad Wasim

236

asked Nov 23 '18 at 11:33

Ammad WasimAmmad Wasim

236

asked Nov 23 '18 at 11:33

Ammad WasimAmmad Wasim

236

236

add a comment | 

add a comment | 

1 Answer
1

active

oldest

votes

0

Most probably you're missing the files listed in one of the following two groups :

• 
  frmwebutil.jar, jacob.jar( perhaps frmall_jinit.jar also )
  files in the formsjava directory
  

or

• 
  jacob-1.14.3-x86.dll, JNIsharedstubs.dll and d2kwut60.dll
  files in the C:Program Files (x86)Javajre1.8.0_xxxbin directory
  

assuming your Oracle Fusion Middleware Home is C:ORACLE_10g. If they do not exist in that directory, it's enough to move them there manually.

• Moreover, they are preferred to be included in the CLASSPATH as CLASSPATH=C:ORACLE_10gformsjavajacob.jar;C:ORACLE_10gformsjavafrmwebutil.jar;
  

and

• Edit file C:Program Files (x86)Javajre1.8.0_xxxlibsecurityjava.policy as adding
  permission java.security.AllPermission; to the bottom of the file
  
  just before the last curly brace with a semi-colon };
  

Just before Forms application runs, Oracle prompts you to sign those files. They needed to be signed with checking always option.

share|improve this answer

edited Jan 1 at 15:24

answered Dec 23 '18 at 22:19

Barbaros ÖzhanBarbaros Özhan

14k71634

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

Thanks for contributing an answer to Stack Overflow!

• Please be sure to answer the question. Provide details and share your research!

But avoid …

• Asking for help, clarification, or responding to other answers.


• Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53445941%2foracle-form-freezes-after-configure-webutil%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

active

oldest

votes

active

oldest

votes

0

Most probably you're missing the files listed in one of the following two groups :

• 
  frmwebutil.jar, jacob.jar( perhaps frmall_jinit.jar also )
  files in the formsjava directory
  

or

• 
  jacob-1.14.3-x86.dll, JNIsharedstubs.dll and d2kwut60.dll
  files in the C:Program Files (x86)Javajre1.8.0_xxxbin directory
  

assuming your Oracle Fusion Middleware Home is C:ORACLE_10g. If they do not exist in that directory, it's enough to move them there manually.

• Moreover, they are preferred to be included in the CLASSPATH as CLASSPATH=C:ORACLE_10gformsjavajacob.jar;C:ORACLE_10gformsjavafrmwebutil.jar;
  

and

• Edit file C:Program Files (x86)Javajre1.8.0_xxxlibsecurityjava.policy as adding
  permission java.security.AllPermission; to the bottom of the file
  
  just before the last curly brace with a semi-colon };
  

Just before Forms application runs, Oracle prompts you to sign those files. They needed to be signed with checking always option.

share|improve this answer

edited Jan 1 at 15:24

answered Dec 23 '18 at 22:19

Barbaros ÖzhanBarbaros Özhan

14k71634

add a comment | 

0

Most probably you're missing the files listed in one of the following two groups :

• 
  frmwebutil.jar, jacob.jar( perhaps frmall_jinit.jar also )
  files in the formsjava directory
  

or

• 
  jacob-1.14.3-x86.dll, JNIsharedstubs.dll and d2kwut60.dll
  files in the C:Program Files (x86)Javajre1.8.0_xxxbin directory
  

assuming your Oracle Fusion Middleware Home is C:ORACLE_10g. If they do not exist in that directory, it's enough to move them there manually.

• Moreover, they are preferred to be included in the CLASSPATH as CLASSPATH=C:ORACLE_10gformsjavajacob.jar;C:ORACLE_10gformsjavafrmwebutil.jar;
  

and

• Edit file C:Program Files (x86)Javajre1.8.0_xxxlibsecurityjava.policy as adding
  permission java.security.AllPermission; to the bottom of the file
  
  just before the last curly brace with a semi-colon };
  

Just before Forms application runs, Oracle prompts you to sign those files. They needed to be signed with checking always option.

share|improve this answer

edited Jan 1 at 15:24

answered Dec 23 '18 at 22:19

Barbaros ÖzhanBarbaros Özhan

14k71634

add a comment | 

0

0

0

Most probably you're missing the files listed in one of the following two groups :

• 
  frmwebutil.jar, jacob.jar( perhaps frmall_jinit.jar also )
  files in the formsjava directory
  

or

• 
  jacob-1.14.3-x86.dll, JNIsharedstubs.dll and d2kwut60.dll
  files in the C:Program Files (x86)Javajre1.8.0_xxxbin directory
  

assuming your Oracle Fusion Middleware Home is C:ORACLE_10g. If they do not exist in that directory, it's enough to move them there manually.

• Moreover, they are preferred to be included in the CLASSPATH as CLASSPATH=C:ORACLE_10gformsjavajacob.jar;C:ORACLE_10gformsjavafrmwebutil.jar;
  

and

• Edit file C:Program Files (x86)Javajre1.8.0_xxxlibsecurityjava.policy as adding
  permission java.security.AllPermission; to the bottom of the file
  
  just before the last curly brace with a semi-colon };
  

Just before Forms application runs, Oracle prompts you to sign those files. They needed to be signed with checking always option.

share|improve this answer

edited Jan 1 at 15:24

answered Dec 23 '18 at 22:19

Barbaros ÖzhanBarbaros Özhan

14k71634

Most probably you're missing the files listed in one of the following two groups :

• 
  frmwebutil.jar, jacob.jar( perhaps frmall_jinit.jar also )
  files in the formsjava directory
  

or

• 
  jacob-1.14.3-x86.dll, JNIsharedstubs.dll and d2kwut60.dll
  files in the C:Program Files (x86)Javajre1.8.0_xxxbin directory
  

assuming your Oracle Fusion Middleware Home is C:ORACLE_10g. If they do not exist in that directory, it's enough to move them there manually.

• Moreover, they are preferred to be included in the CLASSPATH as CLASSPATH=C:ORACLE_10gformsjavajacob.jar;C:ORACLE_10gformsjavafrmwebutil.jar;
  

and

• Edit file C:Program Files (x86)Javajre1.8.0_xxxlibsecurityjava.policy as adding
  permission java.security.AllPermission; to the bottom of the file
  
  just before the last curly brace with a semi-colon };
  

Just before Forms application runs, Oracle prompts you to sign those files. They needed to be signed with checking always option.

share|improve this answer

edited Jan 1 at 15:24

answered Dec 23 '18 at 22:19

Barbaros ÖzhanBarbaros Özhan

14k71634

share|improve this answer

share|improve this answer

edited Jan 1 at 15:24

edited Jan 1 at 15:24

edited Jan 1 at 15:24

answered Dec 23 '18 at 22:19

Barbaros ÖzhanBarbaros Özhan

14k71634

answered Dec 23 '18 at 22:19

Barbaros ÖzhanBarbaros Özhan

14k71634

answered Dec 23 '18 at 22:19

Barbaros ÖzhanBarbaros Özhan

14k71634

14k71634

add a comment | 

add a comment | 

Thanks for contributing an answer to Stack Overflow!

• Please be sure to answer the question. Provide details and share your research!

But avoid …

• Asking for help, clarification, or responding to other answers.


• Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

• Please be sure to answer the question. Provide details and share your research!

But avoid …

• Asking for help, clarification, or responding to other answers.


• Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53445941%2foracle-form-freezes-after-configure-webutil%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

Name

Name

Email

Required, but never shown

Email

Required, but never shown

Email

Required, but never shown

Email

Required, but never shown

Name

Name

Email

Required, but never shown

Email

Required, but never shown

Email

Required, but never shown

Email

Required, but never shown

This page is only for reference, If you need detailed information, please check here