OraFAQ Forum: Forms » How to open pdf files using forms 6i

Home » Developer & Programmer » Forms » How to open pdf files using forms 6i

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

How to open pdf files using forms 6i [message #159292]

Fri, 17 February 2006 03:45

kriti
Messages: 2
Registered: February 2006

Junior Member

How can I open any pdf(Acrobat Reader) file thru Oracle Forms 6i through procedure.
I have written procedure to open .Doc & .XLS files by using OLE2.Create_Object but unable to do for .PDF files.
Plz help me
I m attaching the code in txt file , how i have done it for word
open_word is the name of the procedure/program unit

Attachment: open_word.txt
(Size: 0.99KB, Downloaded 4427 times)

Report message to a moderator

Re: How to open pdf files using forms 6i [message #159387 is a reply to message #159292]

Sat, 18 February 2006 00:03

naif224
Messages: 4
Registered: November 2005
Location: riyadh

Junior Member

You must use OCX to open PDF files .

I will attachment for you a form that open specific PDF files .

and take car before open the form , double click in reg.bat

then open the form .

with regards
NF

Attachment: pdfocx.zip
(Size: 221.78KB, Downloaded 6686 times)

Report message to a moderator

Re: How to open pdf files using forms 6i [message #159905 is a reply to message #159387]

Wed, 22 February 2006 03:10

kriti
Messages: 2
Registered: February 2006

Junior Member

It is not working working properly
And if it works then also it not the actual solution.
i want that when i double click the text item (in which the filename is written), that file should be opened in Acrobat Reader.

Note: in text item item only filename is entered & its path is picked from a variable in which i have stored the whole path i.e. where that file resides

Report message to a moderator

Re: How to open pdf files using forms 6i [message #160025 is a reply to message #159905]

Wed, 22 February 2006 16:13

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have a look at http://www.orafaq.com/forum/t/58701/67467/.

David

Report message to a moderator

Re: How to open pdf files using forms 6i [message #160287 is a reply to message #160025]

Fri, 24 February 2006 05:10

ashishmate
Messages: 90
Registered: February 2005
Location: Mumbai

Member

ashishmate@gmail.com

Hi Kirti

Sorry Yar That (http://www.orafaq.com/forum/t/58701/67467/.
) Code Wont Work in This Condition
Ltl Bit Modification Is Req.

Try This


DECLARE
AppID PLS_INTEGER;
a varchar2(100) := 'C:\ASHish\';
BEGIN
		message(a);message(a);
AppID := DDE.App_Begin('C:\Program Files\Adobe\Acrobat 5.0\Reader\AcroRd32.exe '||a||:your_text_item,DDE.App_Mode_Maximized);
exception when others then 
message(sqlerrm(sqlcode));
END;

If This IS Not Ok Then Tell Me We Will Find Out The Solution

ASHish....

Report message to a moderator

Re: How to open pdf files using forms 6i [message #256789 is a reply to message #160287]

Mon, 06 August 2007 12:17

rajat_chaudhary
Messages: 141
Registered: November 2006
Location: india

Senior Member

1986.chaudhary@gmail.com

hi ashish,

thanks very much yaar , actually i need that code very urgently and i found it in search forum which is given by you....

i am highly thankful to you.......

thanks very much again and again and again.......

can i ask you some more questions ,so could you please give me you mailid on which i forward my query to you.....

rajat chaudhary

Report message to a moderator

Re: How to open pdf files using forms 6i [message #256916 is a reply to message #256789]

Tue, 07 August 2007 02:57

ashishmate
Messages: 90
Registered: February 2005
Location: Mumbai

Member

ashishmate@gmail.com

u can use Private Messaging
ASHish...

Report message to a moderator

Re: How to open pdf files using forms 6i [message #257206 is a reply to message #256916]

Tue, 07 August 2007 14:22

rajat_chaudhary
Messages: 141
Registered: November 2006
Location: india

Senior Member

1986.chaudhary@gmail.com

of fine sir

Report message to a moderator

How to open pdf files using forms 6i [message #417250 is a reply to message #160287]

Thu, 06 August 2009 13:35

antoniapj
Messages: 8
Registered: August 2009

Junior Member

Hi Ashish,

I have the same problem with the file opening pdf from forms 6, although in fact what I need is to recover data of the file, already I open it, but I cannot recover data, you can help me I am using package DDE.

look:

filename := 'C:\file.pdf';
AppID := DDE.App_Begin('C:\Program Files\Adobe\Acrobat 7.0\Acrobat\Acrobat.exe'||' '||filename,DDE.APP_MODE_MAXIMIZED);

ConvID := DDE.Initiate('acroview','control');

DDE.Execute(ConvID,'[DocFind(H:file.pdf),TOTAL,FALSE,FALSE,FALSE]',1000);

--here oracle marks to error NON ORACLE EXCEPTION

not that I can need or that this bad one. I thank for much the aid.

Report message to a moderator

Re: How to open pdf files using forms 6i [message #417274 is a reply to message #417250]

Thu, 06 August 2009 19:55

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Did you use 'message;pause;' pairs to determine which line is failing? Is this your first form? Is this a new Oracle Forms installation?

David

Report message to a moderator

Re: How to open pdf files using forms 6i [message #417366 is a reply to message #417274]

Fri, 07 August 2009 10:47

antoniapj
Messages: 8
Registered: August 2009

Junior Member

Hi David,

Thanks for the aid.

I have put a message to exactly know the line in which it marks error, it is not my first form, but the first time that attempt to recover data of a file pdf, and is not new my installation of forms.

I have a idea, to keep the file like .txt since if I can open the file, but marks the same error to me. The line that use is the following one:

DDE.Execute(ConvID,'[DocOpen(C:\ORIGINAL.pdf)]',1000);
DDE.Execute(ConvID,'[DocSaveAs(C:\ORIGINAL.pdf, C:\nuevo.txt)]',1000);

Greetings!

Report message to a moderator

Re: How to open pdf files using forms 6i [message #417488 is a reply to message #417366]

Sun, 09 August 2009 19:58

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Remember that you have to either duplicate the 'message' command or follow it with a 'pause' command to get the 'real' message to display.

Please post all of your code. Also search this forum for 'pdf'. There are many threads covering the display of pdfs.

David

Report message to a moderator

Re: How to open pdf files using forms 6i [message #417643 is a reply to message #417488]

Mon, 10 August 2009 13:35

antoniapj
Messages: 8
Registered: August 2009

Junior Member

Hi David,

Again, thanks.

The error that marks to me is:

Now with respect to the code, he is everything what I have because what interests to me or what I need is to recover data of a file pdf, but still profit not to save the file like .txt

Regards

Report message to a moderator

Re: How to open pdf files using forms 6i [message #417644 is a reply to message #417643]

Mon, 10 August 2009 14:03

antoniapj
Messages: 8
Registered: August 2009

Junior Member

Sorry,

foget the error: 106555: non-ORACLE exception

Report message to a moderator

Re: How to open pdf files using forms 6i [message #417670 is a reply to message #417644]

Mon, 10 August 2009 20:55

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

I repeat, please post all the code in your trigger and specify on which line it fails. Please use the 'message;pause;' pair method to determine the line which is failing.

David

Report message to a moderator

Re: How to open pdf files using forms 6i [message #417807 is a reply to message #417670]

Tue, 11 August 2009 10:47

antoniapj
Messages: 8
Registered: August 2009

Junior Member

Hi David,

Here code:

DECLARE

filename VARCHAR2(256);
ConvID PLS_INTEGER;
AppID PLS_INTEGER;

BEGIN
filename := 'C:\CSI_DATA\txt\FACTURACION_422_ORIGINAL.pdf';

AppID := DDE.App_Begin('C:\Program Files\Adobe\Acrobat 7.0\Acrobat\Acrobat.exe' ||' '||filename, DDE.APP_MODE_MAXIMIZED);

DDE.App_Focus(AppID);
ConvID := DDE.Initiate('acroview','control');
DDE.Execute(ConvID,'[DocOpen(C:\CSI_DATA\txt\ORIGINAL.pdf)]',1000);
DDE.Execute(ConvID,'[FileOpen(C:\CSI_DATA\txt\ORIGINAL.pdf)]',1000);
DDE.Execute(ConvID,'[DocGoTo(C:\CSI_DATA\txt\ORIGINAL.pdf, 30)]',1000);
DDE.Execute(ConvID,'[DocDeletePages(C:\CSI_DATA\txt\ORIGINAL.pdf, 29, 29)]',1000);
DDE.Execute(ConvID,'[DocSaveAs(C:\CSI_DATA\txt\ORIGINAL.pdf, C:\CSI_DATA\txt\Nueva.txt)]',5000); --this line failed

EXCEPTION
WHEN DDE.DDE_APP_NOT_FOUND THEN
MESSAGE('APP NOT FOUND');
WHEN DDE.DDE_APP_FAILURE THEN
MESSAGE('APP FAILED');
WHEN DDE.DDE_INIT_FAILED THEN
MESSAGE('INIT FAILED');
WHEN DDE.DMLERR_NO_CONV_ESTABLISHED THEN
MESSAGE('CLIENT FAILED TO ESTABLISH CONVERSATION');
WHEN OTHERS THEN
MESSAGE(SQLERRM);
END;

Thanks.

Report message to a moderator

Re: How to open pdf files using forms 6i [message #418070 is a reply to message #417807]

Wed, 12 August 2009 19:54

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Searching this forum for 'dde.app_begin' returned http://www.orafaq.com/forum/m/404889/67467/?srch=DDE.App_Begin#msg_404889 Try this alternate method of determining the path to 'acrobat.exe'.

Let's go back just a bit, have you added new code to this form? Perhaps a new library call? Did you do a Ctrl-Shft-K (Compile All) before Ctrl-t (Generate)?

David

Report message to a moderator

Re: How to open pdf files using forms 6i [message #418245 is a reply to message #418070]

Thu, 13 August 2009 11:11

antoniapj
Messages: 8
Registered: August 2009

Junior Member

Hi,
I do Ctrl-Shft-K (Compile All), but my problem follow.

I don't added new code or library. Some other idea, my form if it open acrobat, but what it does not work is the DocSaveAs

Thanks a lot.

Regards!

Report message to a moderator

Re: How to open pdf files using forms 6i [message #418291 is a reply to message #418245]

Thu, 13 August 2009 20:52

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Googling 'DocSaveAs' found http://msdn.microsoft.com/en-us/library/microsoft.office.tools.word.document.saveas(VS.80).aspx and http://www.acrobatusers.com/forums/aucbb/viewtopic.php?id=6647 and http://www.acrobatusers.com/forums/aucbb/viewtopic.php?id=6636 plus others in the Acrobat User Community Forums.

David

Report message to a moderator

Re: How to open pdf files using forms 6i [message #529511 is a reply to message #159292]

Tue, 01 November 2011 11:43

inspirer2008
Messages: 3
Registered: October 2011
Location: Jordan

Junior Member

Hi

Try to use this

host('cmd /c start '||DOC_FILE_PATH, no_screen);

Regards

Report message to a moderator

Previous Topic:	No data in list item (merged 3)
Next Topic:	in INSERT mode when enter some field and the i press botton

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Apr 28 01:13:13 CDT 2024