| How to access pdf file from server [message #335514] |
Tue, 22 July 2008 07:01  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
