OraFAQ Forum: Forms » Show a pdf file into Forms Developersuite10gR1

Home » Developer & Programmer » Forms » Show a pdf file into Forms Developersuite10gR1 (DeveloperSuit10gR1(9.0.1.5.1))

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Show a pdf file into Forms Developersuite10gR1 [message #438425]

Fri, 08 January 2010 22:50

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.

Report message to a moderator

Re: Show a pdf file into Forms Developersuite10gR1 [message #438726 is a reply to message #438425]

Mon, 11 January 2010 23:50

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: Show a pdf file into Forms Developersuite10gR1 [message #438767 is a reply to message #438726]

Tue, 12 January 2010 02:44

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.

Report message to a moderator

Re: Show a pdf file into Forms Developersuite10gR1 [message #438894 is a reply to message #438767]

Tue, 12 January 2010 21:39

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: Show a pdf file into Forms Developersuite10gR1 [message #438901 is a reply to message #438894]

Tue, 12 January 2010 22:59

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.

Report message to a moderator

Re: Show a pdf file into Forms Developersuite10gR1 [message #439065 is a reply to message #438901]

Wed, 13 January 2010 22:51

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 04:56:56 CDT 2024