OraFAQ Forum: Forms » FORMS 12C: WEB.SHOW_DOCUMENT() is NOT WORKING (5 merged)

Home » Developer & Programmer » Forms » FORMS 12C: WEB.SHOW_DOCUMENT() is NOT WORKING (5 merged) (Oracle Forms 12c, Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

FORMS 12C: WEB.SHOW_DOCUMENT() is NOT WORKING (5 merged) [message #685356]

Thu, 16 December 2021 12:17

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.

Report message to a moderator

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

Littlefoot
Messages: 21823
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).

Report message to a moderator

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

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.

Report message to a moderator

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

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