Home » Developer & Programmer » Forms » Automatically opening pdf file in adobe using pl/sql
Automatically opening pdf file in adobe using pl/sql [message #298867] Fri, 08 February 2008 01:23 Go to next message
bravi_kr
Messages: 3
Registered: February 2008
Location: Bangalore
Junior Member
Hi,

I have a requirement.

I need to open a file in pl/sql. The file, which is to be opened is at Unix.

The file should be opened on clients PC for editing/viewing. The file to be opened will be of pdf format.

The requirement is
PDF File should be brought from unix and should be openened in adobe acrobat on clients PC for veiwing.

Please help me how to do this.

Thanks
Ravi

Re: Automatically opening pdf file in adobe using pl/sql [message #298869 is a reply to message #298867] Fri, 08 February 2008 01:28 Go to previous messageGo to next message
mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi
Senior Member
search it in forum.

you will have answer certainly.

regards,
Re: Automatically opening pdf file in adobe using pl/sql [message #298871 is a reply to message #298867] Fri, 08 February 2008 01:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is the problem of your application not Oracle.
Oracle will return the BLOB containing the file, you do what you want with it.

By the way, PL/SQL does not interact with client only with server.

Regards
Michel
Re: Automatically opening pdf file in adobe using pl/sql [message #298873 is a reply to message #298867] Fri, 08 February 2008 01:40 Go to previous messageGo to next message
bravi_kr
Messages: 3
Registered: February 2008
Location: Bangalore
Junior Member
Hi,

I am searching for any windows API programming concepts from PL/sql.

If I can able to write windows API programming from pl/sql, I can able to have a handle to the file and can be able to open the file for viewing on the PC in which the pl/sql executable is running.

Help me by thinking in that angle.

Thanks
Ravi
Re: Automatically opening pdf file in adobe using pl/sql [message #298879 is a reply to message #298873] Fri, 08 February 2008 01:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
When you say "I can" you meant you wanted to be able to do that, doesn't it?

What I say is that PL/SQL does not interact with client (but may with server).
PL/SQL does not pop up anything.
There is no API for Windows in PL/SQL. Maybe you can write and publish it.

Regards
Michel

Re: Automatically opening pdf file in adobe using pl/sql [message #298884 is a reply to message #298867] Fri, 08 February 2008 02:27 Go to previous messageGo to next message
bravi_kr
Messages: 3
Registered: February 2008
Location: Bangalore
Junior Member
Hi,

The whole process can be done from oracle forms. A file can be opened from forms in PDF/word/excel.

Can it be possible with out using any of the forms code?

This is the actual requirement from clients
====
I am working in Oralce ERP.

1) Client will submit a report from one of the forms.(A request set is submitted using custom.pll)
2) Client will continue his/her work by closing the forms and then opening other forms.
3) A code has to keep on monitor the report that is submitted, and automatically open the output when the report processing is completed.
====

I think I have cleared the requirement.

If I use the BFILE concept, how to handle the BFILE to open the file for viewing.

Thanks
Ravi
Re: Automatically opening pdf file in adobe using pl/sql [message #298886 is a reply to message #298884] Fri, 08 February 2008 02:39 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
PL/SQL is code that runs inside the database, on the server. Acrobat is opened on the client, because a client-side application (forms or a browser) tells Windows that it wants to open a file with a certain content-type.
PL/SQL does not play a role in the actual opening of the file on the client; it is only responsible for sending the file and indicating the content-type.
The receiving application should be the one asking Windows what to do with it.
Re: Automatically opening pdf file in adobe using pl/sql [message #298887 is a reply to message #298884] Fri, 08 February 2008 02:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So this a Forms question.
You likely have a more accurate answer if you post your question in the correct forum.

Regards
Michel
Re: Automatically opening pdf file in adobe using pl/sql [message #298912 is a reply to message #298867] Fri, 08 February 2008 04:31 Go to previous message
rajy_salim
Messages: 204
Registered: January 2008
Location: Beirut - Lebanon
Senior Member
Try to use Host or Client_host method.
Search forums for more information.
Previous Topic: FRM-92101 FAILURE FORM SERVER
Next Topic: Buttons text faded or no text
Goto Forum:
  


Current Time: Sun Dec 04 04:57:20 CST 2016

Total time taken to generate the page: 0.04218 seconds