Hello,
We are working on a project to upgrade an Oracle Forms/Reports application to Oracle Forms/Reports 12.2.1.3.0 version. This application is called Willow and Oracle Forms is installed on AIX7.2 and Reports is installed on Windows 2016 server. Per Oracle recommendation we have configured Willow application to work in FSAL (standalone) mode.
We also have a Java/Primeface application named Vision. Both Willow and Vision work together and lots of times are part of same workflow. At lots of places in Willow application on click of a button we launch Vision application using web.javascript_eval_expr. Vision runs on a Windows 2016 Server on Tomcat.
Now Java Script support is not present with FSAL. Researching for some options I found "Forms Websocket Java Script Integration" (WJSI) from below link:
[explained on Page 9] https://www.oracle.com/technetwork/developer-tools/forms/documentation/oracleforms-12210-newfeatures-2906037.pdf
https://docs.oracle.com/middleware/12213/formsandreports/deploy-forms/oracle-forms-and-javascript-integration.htm#FSDEP4…
Based on above two links I have done following:
1) Signed jetty-all-9.4.5.v20170502-uber.jar file
2) Set variable enableJavascriptEvent in formsweb.cfg
3) Set variable FORMS_ALLOW_JAVASCRIPT_EVENTS in default.env
4) Compiled libraries websocketJSI.olb and websocketJSI.pll
5) I have changed code web.javascript_eval_expr(:block1.JSEXPR); to websocketJSI.javascript_eval_expr(:block1.JSEXPR); in our own PLL file. Above link explains to attach object library to the oracle form from where we are calling html page. Now in our case since call is made from a central pll function. I have not attached object library to it.
I need help with following:
1) After making these changes, when I call Vision from Willow I get attached error: "An exception has occured, calling native screen. ORA-06502: PL/SQL: numeric or value error ORA-01403: no data found" Has anyone seen this error?
2) Has anyone implemented this? If so in which browser will Vision application open? Local Machine default?
3) Since Willow and Vision both run on different servers not sure how to add tag <script type="text/javascript" src="/forms/java/frmwebsocketjsi.js"></script> to Vision primefaces pages?
Let me know if you need any other information? Thanks a ton for helping in this matter.
Thanks,
Saket