This discussion is archived
1 2 Previous Next 28 Replies Latest reply: Apr 9, 2013 7:34 AM by CraigB Go to original post RSS
  • 15. Re: forms not working after upgrade to 11g
    CraigB Guru
    Currently Being Moderated
    ...It points to variable :GLOBAL as a bad bind variable.
    Have you ever been able to compile this library? I attempted to create a new PL/SQL Library with Forms 11g and Forms 10g that referenced a GLOBAL variable and I got the same error. I don't believe you can directly reference a GLOBAL in a PL/SQL Library. You will have to use the NAME_IN() built-in to get the value of a GLOBAL variable. If you need to set the value of a GLOBAL variable in a PL/SQL Library then you would need to assign the value to a local variable first and then use the COPY() built-in to assign the value of the local variable to the GLOBAL variable. For example:
    DECLARE
      v_value_of_Global  VARCHAR2(400);
      v_new_Global_Value VARCHAR2(400);
    BEGIN
      /* Get the value of a GLOBAL Variable */
      v_value_of_Global := Name_IN('GLOBAL.YOUR_GLOBAL_VARIABLE');
      
      /* Assign a value to a GLOBAL Variable */
      v_new_Global_Value := 'This is a new value';
      COPY(v_new_Global_Value, 'GLOBAL.YOUR_GLOBAL_VARIABLE');
    END;
    after running my forms in fusion middleware 11g, i cannot logon to the application from the logon screen but when i clicked the cancel button the screen disappear.
    As to this question, you really should post a new thread as this question doesn't relate to this thread. In your new thread, please list any errors you are receiving. Also, list if you are running your application from your workstation computer or from a server?

    Craig...
  • 16. Re: forms not working after upgrade to 11g
    AbdurRahman Newbie
    Currently Being Moderated
    hello CraigB,

    Thanks for your advice, the library is now fully compiled.but my called forms are still not callable from the menu bar. some forms are callable while other are not. what settings do you really think could be the cause. Anytime i call the forms that don't response my whole applications hangs and those ones that do respond will not respond again.

    Thanks

    Edited by: AbdurRahman on Apr 4, 2013 1:14 PM
  • 17. Re: forms not working after upgrade to 11g
    CraigB Guru
    Currently Being Moderated
    First, I would look at the Java Console log to see if there. Next, I would look at the forms that are not working to see if there is anything common between them; eg: are they using WebUtil, Java Beans, etc. If there are no common elements between the forms, then look at the WLS Forms Services logs to see if there are any errors listed there.

    My guess, is that there is some common element between these forms that is causing the problem.

    Craig...
  • 18. Re: forms not working after upgrade to 11g
    AbdurRahman Newbie
    Currently Being Moderated
    hello CraigB,

    Thanks for your support it s highly appreciated, on looking at the java console below are the error message i came across

    connectMode=HTTP, native.
    Forms Applet version is : 10.1.2.3
    Exception in thread "AWT-EventQueue-2" java.lang.NoSuchMethodError: oracle.forms.handler.IHandler.getApplet()Ljava/applet/Applet;
         at oracle.forms.webutil.common.VBeanCommon.init(VBeanCommon.java:281)
         at oracle.forms.handler.UICommon.instantiate(Unknown Source)
         at oracle.forms.handler.UICommon.onCreate(Unknown Source)
         at oracle.forms.handler.JavaContainer.onCreate(Unknown Source)
         at oracle.forms.engine.Runform.onCreateHandler(Unknown Source)
         at oracle.forms.engine.Runform.processMessage(Unknown Source)
         at oracle.forms.engine.Runform.processSet(Unknown Source)
         at oracle.forms.engine.Runform.onMessageReal(Unknown Source)
         at oracle.forms.engine.Runform.onMessage(Unknown Source)
         at oracle.forms.engine.Runform.processEventEnd(Unknown Source)
         at oracle.ewt.lwAWT.LWComponent.redispatchEvent(Unknown Source)
         at oracle.ewt.lwAWT.LWComponent.processEvent(Unknown Source)
         at java.awt.Component.dispatchEventImpl(Unknown Source)
         at java.awt.Container.dispatchEventImpl(Unknown Source)
         at java.awt.Component.dispatchEvent(Unknown Source)
         at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
         at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
         at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
         at java.awt.Container.dispatchEventImpl(Unknown Source)
         at java.awt.Window.dispatchEventImpl(Unknown Source)
         at java.awt.Component.dispatchEvent(Unknown Source)
         at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
         at java.awt.EventQueue.access$400(Unknown Source)
         at java.awt.EventQueue$2.run(Unknown Source)
         at java.awt.EventQueue$2.run(Unknown Source)
         at java.security.AccessController.doPrivileged(Native Method)
         at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
         at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
         at java.awt.EventQueue$3.run(Unknown Source)
         at java.awt.EventQueue$3.run(Unknown Source)
         at java.security.AccessController.doPrivileged(Native Method)
         at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
         at java.awt.EventQueue.dispatchEvent(Unknown Source)
         at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
         at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
         at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
         at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
         at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
         at java.awt.EventDispatchThread.run(Unknown Source)

    the form is actually using webutil when i removed the webutil canvas and block.i could not compile the form. what can i do in that respect.
  • 19. Re: forms not working after upgrade to 11g
    AlexDiniasi Journeyer
    Currently Being Moderated
    Hello Abdur,

    As per the java console message:

    connectMode=HTTP, native.
    Forms Applet version is : 10.1.2.3
    Exception in thread "AWT-EventQueue-2" java.lang.NoSuchMethodError: oracle.forms.handler.IHandler.getApplet()Ljava/applet/Applet;
    at oracle.forms.webutil.common.VBeanCommon.init(VBeanCommon.java:281)


    It seems that you are using frmall.jar from 10g installation and not from 11g.

    Please make sure you have the correct 11g frmall.jar in ORACLE_HOME/forms/java.

    A restart of the WLS_FORMS is required after the jar files are modified.Also clear the java cache on the client machine.


    I would suggest to use default configuration and run a form that is not using webutil.
    It this goes well you can proceed to the next step: Configure webutil: How to Configure Webutil in Forms 11g (Doc ID 1093985.1)

    Kind regards,
    Alex


    If someone's answer is helpful or correct please mark it accordingly.
  • 20. Re: forms not working after upgrade to 11g
    AbdurRahman Newbie
    Currently Being Moderated
    hello Alex

    Thanks for your advice,the form i am calling uses a webutil and the jre i am using is this
    Java Plug-in 1.6.0_43
    Using JRE version 1.6.0_43-b01 Java HotSpot(TM) Client VM

    when i call another form, it comes up perfectly,but for this particular one it throws the error out in the java console.
    also i dont have access to my support page for now, can you be of help in that regards please.

    Thanks
  • 21. Re: forms not working after upgrade to 11g
    HamidHelal Guru
    Currently Being Moderated
    AbdurRahman wrote:
    hello Alex

    Thanks for your advice,the form i am calling uses a webutil and the jre i am using is this
    Java Plug-in 1.6.0_43
    Using JRE version 1.6.0_43-b01 Java HotSpot(TM) Client VM

    when i call another form, it comes up perfectly,but for this particular one it throws the error out in the java console.
    also i dont have access to my support page for now, can you be of help in that regards please.

    Thanks
    First of all , let us inform, other then webutil form works perfectly ?
    If webutil form is the issue yes it should be as 10g and 11g forms webutil is not same. check this link http://blog.newtrics.com/?p=1037

    Hope this helps


    Hamid
  • 22. Re: forms not working after upgrade to 11g
    AbdurRahman Newbie
    Currently Being Moderated
    can i use this step for linux server as well?

    thanks
  • 23. Re: forms not working after upgrade to 11g
    HamidHelal Guru
    Currently Being Moderated
    AbdurRahman wrote:
    can i use this step for linux server as well?

    thanks
    NO, Above link is for Windows. Here for Linux http://kpsoft-tech-blogs.blogspot.com/2012/05/forms-11g-webutil-configuration.html

    Hope this helps

    Hamid
  • 24. Re: forms not working after upgrade to 11g
    AbdurRahman Newbie
    Currently Being Moderated
    thanks Hamid,

    i did follow the steps and i was able to launch the forms initially without any issue. after logging out and trying to launch the whole application, the whole application freezed.
    i could not go forward or backward.

    i had this warning -security window that is displayed with this message The application's digital signature cannot be verified. Do you want to run the application? i tried to click the run button nothing happens. have i done something wrong? if yes what could it be.

    Thanks
  • 25. Re: forms not working after upgrade to 11g
    HamidHelal Guru
    Currently Being Moderated
    AbdurRahman wrote:
    thanks Hamid,

    i did follow the steps and i was able to launch the forms initially without any issue. after logging out and trying to launch the whole application, the whole application
    >freezed.
    What that mean. First of all make sure you are able to login then except webutil form, others are working fine ? When the application freeze ? In a specific form open time ?
    i could not go forward or backward.
    First did you run the webutil demo successfully according to link?
    i had this warning -security window that is displayed with this message The application's digital signature cannot be verified. Do you want to run the application? i tried to click the run button nothing happens. have i done something wrong? if yes what could it be.
    Did you sign the jar files with sign_webuitl.bat?

    check the JRE console log.

    Hope this helps

    Hamid

    If someone's response is helpful or correct, please mark it accordingly.*
  • 26. Re: forms not working after upgrade to 11g
    AbdurRahman Newbie
    Currently Being Moderated
    The whole application freezes when i launched it from the browser.i can not even call any forms.

    To your second question yes i did but i got this error message WUC-24:error reading url and wuc-19:unable to write to localfile:\    .failed to download url when i logged in.

    To your third question i did the jar file with sign_webutil.sh. the jre console log is not responding to mouse clicking at all.

    the whole application just freeze up.

    Thanks
  • 27. Re: forms not working after upgrade to 11g
    AbdurRahman Newbie
    Currently Being Moderated
    hello all,

    In addition to my observation, is it possible for webutil version 11.1.1.6 to work with JRE version 1.6.0_43-b01?

    I am asking this question because during the process of startup my forms application hangs when it gets to this stage?

    Thanks
  • 28. Re: forms not working after upgrade to 11g
    CraigB Guru
    Currently Being Moderated
    In your searches, did you happen to run across this thread ( wuc-24 error reading url jacob.dll forms 11gr2 )? Have you tried recompiling the webutil.plx?

    Craig...
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points