473,549 Members | 2,627 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

view pdf in oracle forms

13 New Member
hi im using oracle forms 6i.
i need to view a pdf in oracle forms runtime window itself
the pdf name will differ depending on the previous parameter.
i need to show the pdf in an object in the canvas.


to explain roughly

i need an object/box in the canvas, in which the clients can view a pdf.
the pdf should not open in new window, so that i can restrict the user to do save as/print....
Dec 28 '09 #1
4 19263
amitpatel66
2,367 Recognized Expert Top Contributor
Try this:

Expand|Select|Wrap|Line Numbers
  1. DECLARE
  2. AppID PLS_INTEGER;
  3. a varchar2(100) := 'C:\';
  4. BEGIN
  5. AppID := DDE.App_Begin('C:\Program Files\Adobe\Acrobat 5.0\Reader\AcroRd32.exe '||a||:your_text_item,DDE.App_Mode_Maximized);
  6. exception when others then 
  7. message(sqlerrm(sqlcode));
  8. END;
  9.  
Dec 28 '09 #2
cmuraz
13 New Member
thanks for the reply dude...

but i used this code already.

this will open the pdf separately. i dont want tat.

what i need is that i have to open the pdf files in the form itself [embedded in any object]
Dec 29 '09 #3
amitpatel66
2,367 Recognized Expert Top Contributor
Check this:

Syntax:

SHOW_DOCUMENT(u rl, target);

Description:

Specifies the URL and target window of a Web application.

Parameters:

url Datatype is VARCHAR2. Specifies the Uniform Resource Locator of the document to be loaded.

target Datatype is VARCHAR2. Specifies one of the following targets:

_SELF Causes the document to load into the same frame or window as the source document.

_PARENT Causes the target document to load into the parent window or frameset containing the hypertext reference. If the reference is in a window or top-level frame, it is equivalent to the target _self.

_TOP Causes the document to load into the window containing the hypertext link, replacing any frames currently displayed in the window.

_BLANK Causes the document to load into a new, unnamed top-level window.

Restrictions:

Can only be used from within a form run from the Web.

Example:

Expand|Select|Wrap|Line Numbers
  1.  
  2. BEGIN 
  3.   Web.Show_Document(‘http://www.abc.com’, ‘_self’); 
  4. END; 
  5.  
  6.  
Dec 29 '09 #4
cmuraz
13 New Member
that similar to html codings rite?

but we dont use the web appln.

we use only the windows appln for all other purposes.

anyway thanks for the effort. if you have any other method regarding this, pl intimate me.

thanks a lot.
muthu
Dec 29 '09 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

2
4001
by: Kaix | last post by:
Hello, is there a possibility to control oracle forms form a external application. I like to push a value in a text field in a oracle forms app and "press" a button in this form. Maybe i can use OLE like EXTRA Attchmate. Thanks. Kai
1
8017
by: MEG | last post by:
Hi, I am trying to do some authentification in a form and have run into a problem. The user types the usename/password into a couple of fields and presses the login button. The button trigger PL/SQL looks like this : DECLARE uservar VARCHAR2(15) := '';
2
2965
by: Azhar Bilgrami | last post by:
Hi: I want to Migrate Oracle form 3 to Oracle forms 6i, but I couldnt find that software on Oracle Website, can u please Help me?. Take care of ure self. Azhar
1
3935
by: Chris | last post by:
Our company developed the last couple of years a development tool: using this tool we configure and program (using SQL, and Java-Script) very, very easy an application. The output of the effort is a state-of-the art n-tier, j2ee, pure-java/xml-Application - but without coding one single line java. And: the application looks really sexy. Some...
2
9411
by: Thomas Kindermann | last post by:
Hello everyone, I'm an oracle database adminstrator and I search some information about possibilities to create easy forms for data input (for example for test data). My Oracle release is now currently 9.2.0.5 Now i try use the Oracle Forms application. I try to install the version 'Forms 6i R2' on my client PC with Windows
1
2586
by: tristant | last post by:
Hi all I need to make decision on which development tool to use: Oracle Forms or Visual Studio .Net. We run Oracle 9i on AIX. And we will develope database application. If use .NET we will use win2003 as App server. Could any pls give me argument which tool is better ? Will there be any issues or problems I might faced if we standadised...
0
7073
by: anuj13singhal | last post by:
Hi, I am trying to open a word document on the client machine. the document is present on the oracle application server (on windows). For that I have created a java class file wordbean.class. (Source code below) package oracle.forms.demos.ole; import com.jacob.activeX.ActiveXComponent; import java.awt.Panel; import com.jacob.com.*;
5
4636
by: paulnamroud | last post by:
Hi all, We have an application written with Oracle Forms 5.0 and report builder 3.05. We are using Oracle 8i as a database. We have around 50 forms and 10 reports. I'm in a process of analysing and evaluating to upgrade/migrate or rewrite this application with a new tool in order to convert it on a web application. I have made few search...
1
3062
by: Samarjit | last post by:
Hi, I just want to know whether Oracle forms 11g supports other databases like DB2, SQL Server etc. Also does Oracle forms 11g supports Oracle database 9i or 10g apart from 11g?
0
7521
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
1
7473
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7810
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6044
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5369
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5088
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3501
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
1944
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1061
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.