OraFAQ Forum: Forms » How to show report output from a plsql proc back on a form

Home » Developer & Programmer » Forms » How to show report output from a plsql proc back on a form

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

How to show report output from a plsql proc back on a form [message #255705]

Wed, 01 August 2007 09:26

mungeroo
Messages: 6
Registered: July 2007

Junior Member

Using Forms 10g I execute a plsql procedure which produces a text report file. What is the best way to display this report back to the user of the form? WEB.SHOW_DOCUMENT is not what I am looking for, as it requires placing the output to a URL addressable location. I want to display the report from where it is generated in the user's default directory.
Anyone?

Report message to a moderator

Re: How to show report output from a plsql proc back on a form [message #256106 is a reply to message #255705]

Fri, 03 August 2007 01:23

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have you considered using a simple text editor invoked by the 'client_host' command?

David

Report message to a moderator

Re: How to show report output from a plsql proc back on a form [message #256238 is a reply to message #256106]

Fri, 03 August 2007 09:02

mungeroo
Messages: 6
Registered: July 2007

Junior Member

That would require using WebUtil and I want to keep everything on the server side. Is there a way to run WEB.SHOW_DOCUMENT so that it will display a file from ANY directory?

Thanks for your idea,
Mike

Report message to a moderator

Re: How to show report output from a plsql proc back on a form [message #256599 is a reply to message #256238]

Mon, 06 August 2007 01:48

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

If you want to show a file on the server then use the 'host' command.

David

Report message to a moderator

Re: How to show report output from a plsql proc back on a form [message #256617 is a reply to message #256599]

Mon, 06 August 2007 02:20

mungeroo
Messages: 6
Registered: July 2007

Junior Member

You are forgetting that any output from the server will NOT be seen by the user. This is Forms 10g, server HOST command output is not shown to the user who is on a client BROWSER.

Report message to a moderator

Re: How to show report output from a plsql proc back on a form [message #256628 is a reply to message #256617]

Mon, 06 August 2007 02:41

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have you considered copying the file to the 'tmp' directory on the PC and then doing a 'client_host' from there? How about giving the user access to a server directory (read-only), save the file in that directory, and using 'client_host' against that entry?

David

Report message to a moderator

Re: How to show report output from a plsql proc back on a form [message #256753 is a reply to message #256628]

Mon, 06 August 2007 09:11

mungeroo
Messages: 6
Registered: July 2007

Junior Member

All these solutions you suggest require WebUtil and are dependent on software on the client side. As we have no control over what software is running on the client to display the file(ie. Notepad etc..), this would be a very awkward way of doing this. If there is a way to use WEB.SHOW_DOCUMENT without the URL address requirement it would be ideal.

Report message to a moderator

Re: How to show report output from a plsql proc back on a form [message #256892 is a reply to message #256753]

Tue, 07 August 2007 00:46

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

By the way, 'webutil' is on the server NOT on the client.

Have you tried just 'executing' the '.txt' file without specifying 'notepad'?

David

Report message to a moderator

Previous Topic:	Error FRM-47335
Next Topic:	Protect Document using Webutil

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 10 11:36:55 CDT 2025