Home » Developer & Programmer » Forms » FORMS 12C: WEB.SHOW_DOCUMENT() is NOT WORKING (5 merged) (Oracle Forms 12c, Windows)
FORMS 12C: WEB.SHOW_DOCUMENT() is NOT WORKING (5 merged) [message #685356] Thu, 16 December 2021 12:17 Go to next message
mg.hossain.it@gmail.com
Messages: 11
Registered: November 2018
Junior Member
I have successfully installed and run oracle forms 12c.
Now trying to compile and run form and call a report by WEB.SHOW_DOCUMENT()

I see,
WEB.SHOW_DOCUMENT('http://www.google.com') 
works fine.

But when I write:
WEB.SHOW_DOCUMENT('http://192.168.42.110:9002/reports/rwservlet?run&destype=CACHE&desformat=PDF&ORIENTATION=LANDSCAPE&userid=U1/UU@TESTPDB&report=\\192.168.42.110\files\test.jsp','samewindow'); 
it does not show anything, neither any error message.

I also noticed that it works only if it starts with http://www.
but as it's my local machine I can not write upto www.

I would be grateful if someone can please help me about how I can show reports with web.show_document() command in Forms 12c.

Thank you in advance.
Re: FORMS 12C: WEB.SHOW_DOCUMENT() is NOT WORKING (5 merged) [message #685361 is a reply to message #685356] Thu, 16 December 2021 14:39 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't have Forms 12c. Also, this (Oracle Forms Services – Secure Web.Show_Document() calls to Oracle Reports) is an old document (dates in 2004), but - I somehow doubt that syntax has changed.

Shortly, if compared to what you used, report comes first; other parameters next.

Also, samewindow? Where is it from? Target can be e.g. "_blank" or "_self", but not "samewindow". Maybe your code will work if you simply remove it (or use a safe _blank option).
Re: FORMS 12C: WEB.SHOW_DOCUMENT() is NOT WORKING (5 merged) [message #685365 is a reply to message #685361] Fri, 17 December 2021 01:56 Go to previous messageGo to next message
mg.hossain.it@gmail.com
Messages: 11
Registered: November 2018
Junior Member
Thank you so very much, sir, for your kind attention and for the courtesy of the reply.

I have tried with '_blank' option, nothing works.

WEB.SHOW_DOCUMENT('http://192.168.42.110:9002/reports/rwservlet?run&destype=CACHE&desformat=PDF&ORIENTATION=LANDSCAPE&userid=U1/UU@TESTPDB&report=\\192.168.42.110\files\test.jsp','_blank'); 

If I copy paste the following code in the address bar of any browser then also it works.
http://192.168.42.110:9002/reports/rwservlet?run&destype=CACHE&desformat=PDF&ORIENTATION=LANDSCAPE&userid=U1/UU@TESTPDB&report=\\192.168.42.110\files\test.jsp

But, if I put the code into Web.show_document() in form, it does not work.


Thank you again for your kind attention to my topic, please.
Re: FORMS 12C: WEB.SHOW_DOCUMENT() is NOT WORKING (5 merged) [message #685369 is a reply to message #685365] Fri, 17 December 2021 07:36 Go to previous messageGo to next message
mg.hossain.it@gmail.com
Messages: 11
Registered: November 2018
Junior Member
My problem has been solved.

I found some problems that barred me from displaying report in the browser with WEB.SHOW_DOCUMENT(), in Forms 12c, most unlike 11g, and the following steps solved the problem:

A) In the browser:
1) Disabled the Pop up blocker in the browser,
2) Put the IP of the computer to the trusted site.

B) In the Java Setting of Control Panel:
Put the IP of the computer in the Exception Site List.

C) Directory Separators in report filename must not be backslash (\), they must be frontslash or slash (/), even in windows,

D) Whole URL must not contain any blank space.

I hope, someone new in forms 12c, like me, may find some way out from above steps.

Best regards to all.

[Updated on: Fri, 17 December 2021 08:45]

Report message to a moderator

Re: FORMS 12C: WEB.SHOW_DOCUMENT() is NOT WORKING (5 merged) [message #685382 is a reply to message #685369] Fri, 17 December 2021 13:48 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Great, I'm glad you made it work! Thank you very much for letting us know how you did it; I'm sure someone else will benefit from it.
Re: FORMS 12C: WEB.SHOW_DOCUMENT() is NOT WORKING (5 merged) [message #685383 is a reply to message #685382] Sat, 18 December 2021 04:54 Go to previous message
mg.hossain.it@gmail.com
Messages: 11
Registered: November 2018
Junior Member
Heartiest thanks to you, too, sir.
Previous Topic: Canvas Color STOPPED changing color programatically
Next Topic: PDF file upload into oracle db columns and showing when it is required
Goto Forum:
  


Current Time: Thu Mar 28 03:57:47 CDT 2024