Home » Developer & Programmer » Forms » How to show report output from a plsql proc back on a form
How to show report output from a plsql proc back on a form [message #255705] Wed, 01 August 2007 09:26 Go to next message
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?
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 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you considered using a simple text editor invoked by the 'client_host' command?

David
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
If you want to show a file on the server then use the 'host' command.

David
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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
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 Go to previous messageGo to next message
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.
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 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: Error FRM-47335
Next Topic: Protect Document using Webutil
Goto Forum:
  


Current Time: Sat Dec 10 14:33:42 CST 2016

Total time taken to generate the page: 0.10578 seconds