Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » How to access pdf file from server (Oracle Apps 11.5.10 , App server Unix-2.6.9)
How to access pdf file from server [message #335514] Tue, 22 July 2008 07:01 Go to next message
sk_imran4u@yahoo.com
Messages: 2
Registered: July 2008
Junior Member
Hi,

I want to access pdf file stored in server and display as output in browser in oracle apps.

I have written a sql script.
DECLARE
str varchar2(1000);
BEGIN
/*********** PDF document to be displayed***********/

select '<html>
<body leftmargin=0 topmargin=0 scroll=no>
<embed width=100% height=100% fullscreen=yes
src="http://applprod@linxusa.cesltd.com/var/tmp/aa.pdf">
</body>
</html>'
into str
from dual;

FND_FILE.PUT_LINE(FND_FILE.OUTPUT,str);

EXCEPTION
when others then
FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
END;



/




This script is in SQL Directory in my Custom Module Top using method type as SQL.
But its not displaying anything in output browser as its unable to access file from server.
If path is of our local machine ie;src="file:///C:/Documents%20and%20Settings/Desktop/aa.pdf">
Then that pdf file is displayed in output browser.

Can anyone suggest me whether the approach is correct or where i am going wrong.
Please suggest me the best possible alternative solution if any.

Thanks & Regards
Oracle Team
Re: How to access pdf file from server [message #335529 is a reply to message #335514] Tue, 22 July 2008 08:14 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow the Posting Guidelines as stated in URL above
Previous Topic: IAS Report Server
Next Topic: provider cannot be found.It may not be installed properly
Goto Forum:
  


Current Time: Thu Dec 08 14:34:47 CST 2016

Total time taken to generate the page: 0.15885 seconds