Home » Developer & Programmer » Forms » missing file c:\layout\awc\mystyle.css (software Forms [32 Bit] Version 9.0.2.9.0 , oracle JInitiator: 1.3.1.9, WebUtil 1.0.2(Beta), window , IE 8)
missing file c:\layout\awc\mystyle.css [message #608820] |
Tue, 25 February 2014 04:05 |
meteo
Messages: 89 Registered: April 2010 Location: beirut
|
Member |
|
|
i write a procedure that read a content of html file to CLOB variable to finally create this CLOB to metar_xls.xls file in c:\climate_file\
this procedure is :
P4_FIRE_HTML_TRIGGER_ARG
(p_airpcode in varchar2, File_Metar OUT CLOB, file_txt in varchar2 )
AS
req UTL_HTTP.REQ;
resp UTL_HTTP.RESP;
i integer ;
string_in_file varchar2(32500);
BEGIN
string_in_file :='';
DBMS_OUTPUT.ENABLE(3000000);
req := UTL_HTTP.BEGIN_REQUEST ('http://aviati ................................');
UTL_HTTP.SET_HEADER(req, 'User-Agent', 'IE8');
resp := UTL_HTTP.GET_RESPONSE(req);
USING_CLOB.LOB_INS(1,'Metar_taf', '/' );
LOOP
UTL_HTTP.READ_LINE(resp, File_Metar , TRUE);
string_in_file := string_in_file || File_Metar;
USING_CLOB.ADD_MORE (1, File_Metar );
END LOOP;
UTL_HTTP.END_RESPONSE(resp);
EXCEPTION
WHEN UTL_HTTP.END_OF_BODY THEN
P92_FETCH_CLOB_TO_FILE ( FILE_TXT ||'.'||'xls', string_in_file ); this procedure create the excel file in c:\climate_file\
UTL_HTTP.END_RESPONSE(resp);
END;
-- -----------------------------------------------
also
the called procedure is
P92_FETCH_CLOB_TO_FILE
( p_filetxt IN VARCHAR2,
p_string IN VARCHAR2
)
AS
c_amount CONSTANT BINARY_INTEGER := 32767;
l_buffer VARCHAR2(32767);
l_chr10 PLS_INTEGER;
l_clobLen PLS_INTEGER;
l_fHandler UTL_FILE.FILE_TYPE;
l_pos PLS_INTEGER := 1;
BEGIN
l_clobLen := DBMS_LOB.GETLENGTH( p_string);
l_fHandler := UTL_FILE.FOPEN('LOG_DIR2', p_filetxt, 'W',c_amount);
WHILE l_pos < l_clobLen LOOP
l_buffer := DBMS_LOB.SUBSTR(p_string, c_amount, l_pos);
EXIT WHEN l_buffer IS NULL;
l_chr10 := INSTR(l_buffer,CHR(10),-1);
IF l_chr10 != 0 THEN
l_buffer := SUBSTR(l_buffer,1,l_chr10-1);
END IF;
UTL_FILE.PUT_LINE(l_fHandler, l_buffer,TRUE);
l_pos := l_pos + LEAST(LENGTH(l_buffer)+1,c_amount);
END LOOP;
UTL_FILE.FCLOSE(l_fHandler);
EXCEPTION
WHEN OTHERS THEN
IF UTL_FILE.IS_OPEN(l_fHandler) THEN
UTL_FILE.FCLOSE(l_fHandler);
END IF;
RAISE;
END;
-- --------------------
from isqlplus i execute the following block:
SET SERVEROUTPUT ON;
DECLARE
file_metar clob;
METAR_XLS varchar2(200);
BEGIN
P4_FIRE_HTML_TRIGGER_ARG ('OLBA+LCLK+LFPO+OEJN', file_metar, 'METAR_XLS');
END;
-----------------------------------------------
the execution of this block is well completed, and the file FILE_METAR.xls that contains all the data found in the file_metar CLOB
is also well created.
just when i tried to double click on FILE_METAR.xls a message error i have received :missing file c:\layout\awc\mystyle.css
since if i click ok when the mentioned message is loaded, this file is opened and all data are found inside.
how can i get free from this error message
Thank you
|
|
|
Goto Forum:
Current Time: Mon Aug 26 07:20:09 CDT 2024
|