Home » Developer & Programmer » Forms » Show a pdf file into Forms Developersuite10gR1 (DeveloperSuit10gR1(9.0.1.5.1))
Show a pdf file into Forms Developersuite10gR1 [message #438425] Fri, 08 January 2010 22:50 Go to next message
tamzidulamin
Messages: 132
Registered: October 2009
Location: Dhaka
Senior Member
Dear,

I want to show a pdf file into my Forms or
show as external pdf file which is stored
my database blob column.My forms run into browser.
How can i solve my problem?

Have any builtin in Webutil functions...?

Regards.
Tamzidul Amin.
Re: Show a pdf file into Forms Developersuite10gR1 [message #438726 is a reply to message #438425] Mon, 11 January 2010 23:50 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Try using 'web.show_document' to show your 'pdf' document. (Also search 'show pdf'.)

To store a 'pdf' in the 'database, search this forum for 'store pdf'. See http://www.orafaq.com/forum/m/426585/67467/?srch=store+pdf#msg_426585 as an example.

David
Re: Show a pdf file into Forms Developersuite10gR1 [message #438767 is a reply to message #438726] Tue, 12 January 2010 02:44 Go to previous messageGo to next message
tamzidulamin
Messages: 132
Registered: October 2009
Location: Dhaka
Senior Member
I have solve my Problem by the following way:

If    WEBUTIL_FILE_TRANSFER.DB_To_Client ( clientFile       => 'C:\Test.pdf' , 
                                           tableName        => 'Table_Name'  , 
                                           columnName       => 'Blob_Column' ,
                                           whereClause      => 'Where_Clause'
                                          ) 
      then  WEBUTIL_HOST.Host('IEXPLORE.EXE '||'C:\Test.pdf');                   

End If; 
 


Have u any alternate idea...

Regards
Tamzidul Amin.
Re: Show a pdf file into Forms Developersuite10gR1 [message #438894 is a reply to message #438767] Tue, 12 January 2010 21:39 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
You could use 'webutil' to find the 'temporary' disk location and copy your files to that location instead of 'c:'.

You may also want to delete the file once the user has finished looking at it.

David
Re: Show a pdf file into Forms Developersuite10gR1 [message #438901 is a reply to message #438894] Tue, 12 January 2010 22:59 Go to previous messageGo to next message
tamzidulamin
Messages: 132
Registered: October 2009
Location: Dhaka
Senior Member
djmartin wrote on Wed, 13 January 2010 09:39
You could use 'webutil' to find the 'temporary' disk location and copy your files to that location instead of 'c:'.

You may also want to delete the file once the user has finished looking at it.

David


Dear David,

Can u clear me that, how to use temporary location in C drive
and delete the file after user saw that file?

Thanks.
Tamzidul Amin.
Re: Show a pdf file into Forms Developersuite10gR1 [message #439065 is a reply to message #438901] Wed, 13 January 2010 22:51 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Google for "Oracle® Forms Developer, WebUtil User's Guide, Release 1.0.6" and in it go to section '4.2 Ported D2KWUTIL Functions' and look at 'Get_Temp_Directory'.

To delete a file go to section '4.3.3 WebUtil_File' and look at 'Delete_File'. You can also use 'client_host' to issue an OS 'delete'.

David
Previous Topic: Excute Procedure When Value Is In Variable
Next Topic: WEBUTIL_FILE_TRANSFER
Goto Forum:
  


Current Time: Wed Sep 28 16:05:14 CDT 2016

Total time taken to generate the page: 0.06400 seconds