...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?
AbdurRahman wrote:First of all , let us inform, other then webutil form works perfectly ?
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.
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
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?