Home » Developer & Programmer » Forms » forms 10g application error (oracle forms: 10G: windows xp)
forms 10g application error [message #348427] Tue, 16 September 2008 13:45 Go to next message
deba_skr
Messages: 2
Registered: September 2008
Junior Member
Hi,

Please help me.. I am finding problem to open .xls file in oracle forms 10g

I need some urgent help.. Please help me!!
tried to execute a program code on forms 10g from client machin which runs on windows XP and using application server which is unix server.
it opens a .xls file

it gives error. which I am not able to debug

use the following command :
the program code is given below:


DECLARE
v_file VARCHAR2(2000);
url VARCHAR2(2000);
-- err_code CONSTANT NUMBER := SQLERR;
BEGIN
v_file := :Registration.file_path||'\'||:Registration.file_name;
-- HOST(v_file, NO_SCREEN);

-- Client_Host('C:\WINNT\system32\cmd.exe /C'||v_file);
url := 'forms/frmservlet?config=sabam-dev&userid=xxx_yyy/<pswd>@db';
';
web.show_document(url,v_file);
END IF;
EXCEPTION WHEN OTHERS THEN
MESSAGE(SQLERRM);
END;


Thank in advance
Deba
Re: forms 10g application error [message #348773 is a reply to message #348427] Wed, 17 September 2008 23:05 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Please read the forum guidelines at http://www.orafaq.com/forum/t/88153/0/

Specifically, format your code!!! Just formatting it will often show your problem. Why do you have a line that just contains a quote and a semi-colon?

What is the error message that you receiving?

David
Previous Topic: Form Error
Next Topic: Querying an particular Field issue ..
Goto Forum:
  


Current Time: Wed Nov 13 05:01:21 CST 2024