Home » Developer & Programmer » Forms » Tiff file not open in oracle forms 6i (oralce forms 6i windows xp)
Tiff file not open in oracle forms 6i [message #626235] Thu, 23 October 2014 03:25 Go to next message
Messages: 4
Registered: June 2014
Location: chennai
Junior Member


please help me very urgent

i am using orcale 6i forms application i want to open to pdf and tiff format document but pdf file only open while
clicking the button using when button pressed trigger .

i can't open tiff format file..

i have attched query.

filename VARCHAR2(200);
filename1 VARCHAR2(200);
V_path varchar(100) :='E:\';
fpath varchar2(100);
--file_path varchar2(100);
image varchar2(100);

--SELECT PATH_DESC INTO file_path FROM IMAGE_PATH where image_type='SCANNED';

select path into fpath from image_folder
where scan_year =substr(:b010.job_no,1,4) and from_no<=substr(:b010.job_no,6,9)
and to_no>=substr(:b010.job_no,6,9);

select image_type into image from image_path where image_type='.PDF' or image_type='.tif' ;

filename := V_path||substr(:b010.job_no,1,4)||'\'||fpath||'\'||:b010.job_no||'\'||:b010.job_no||image;
host('start '||filename);

Re: Tiff file not open in oracle forms 6i [message #626248 is a reply to message #626235] Thu, 23 October 2014 08:51 Go to previous message
Messages: 386
Registered: August 2014
Location: Utah, USA
Senior Member
i can't open tiff format file..

What happens when you try to open a tiff? If we don't know what happens, we have to guess.

So, my guess is that you don't have a default application associated with the .tiff extension.

Previous Topic: Form Navigate Abnormally
Next Topic: Oracle Forms App for Android, is there one for iOS also?
Goto Forum:

Current Time: Mon Dec 11 01:07:24 CST 2017

Total time taken to generate the page: 0.01604 seconds