| Automatically opening pdf file in adobe using pl/sql [message #298867] |
Fri, 08 February 2008 01:23  |
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 #298873 is a reply to message #298867] |
Fri, 08 February 2008 01:40  |
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 #298884 is a reply to message #298867] |
Fri, 08 February 2008 02:27 |
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 |
Frank
Messages: 7901
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.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
