Hi Mr just I would like to be sure about my procedure out put t!! I write the following procedure
phtml (p_airpcode in varchar2, File_Metar OUT CLOB)
AS
req UTL_HTTP.REQ;
resp UTL_HTTP.RESP;
i integer ;
BEGIN
DBMS_OUTPUT.ENABLE(3000000);
req := UTL_HTTP.BEGIN_REQUEST ('http://....................................................................');
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);
p2_putlines(File_Metar );
USING_CLOB.ADD_MORE (1, File_Metar );
USING_CLOB.LOB_INS(1,'Metar_taf', File_Metar );
END LOOP;
UTL_HTTP.END_RESPONSE(resp);
EXCEPTION
WHEN UTL_HTTP.END_OF_BODY THEN
UTL_HTTP.END_RESPONSE(resp);
END;
after the execution l have got the procedure out put :
DOC_ID NAME DOC
----------------------------------------------------------------------------------
1 Metar_taf </TD> </TR>
1 Metar_taf </TR> <TR VALIGN="top">
1 Metar_taf <TR VALIGN="top"> <TD ALIGN="left" COLSPAN="2">
1 Metar_taf <TD ALIGN="left" COLSPAN="2"><FONT FACE="Monospace,Courier">OLBA 140800Z V
1 Metar_taf <FONT FACE="Monospace,Courier">OLBA 140800Z VRB03KT 8000 FEW200 20/13 Q1014</FON
1 Metar_taf <FONT FACE="Monospace,Courier">OSDI 140800Z 06012KT CAVOK 12/M06 Q1017</FONT><BR
1 Metar_taf <FONT FACE="Monospace,Courier">OJAM 140800Z 04004KT 5000 HZ NSC 10/M06 Q1016 NOS
1 Metar_taf <FONT FACE="Monospace,Courier">OEJN 140800Z 12006KT 9999 FEW040 31/09 Q1012 NOSI
is this a logical result??? because i think it should be like this
DOC_ID NAME DOC
------------------------------------------------------------------------------
1 Metar_taf </TD> </TR>
</TR> <TR VALIGN="top">
<TR VALIGN="top"> <TD ALIGN="left" COLSPAN="2">
<TD ALIGN="left" COLSPAN="2"><FONT FACE="Monospace,Courier">OLBA 140800Z V
<FONT FACE="Monospace,Courier">OLBA 140800Z VRB03KT 8000 FEW200 20/13 Q1014</FON
<FONT FACE="Monospace,Courier">OSDI 140800Z 06012KT CAVOK 12/M06 Q1017</FONT><BR
<FONT FACE="Monospace,Courier">OJAM 140800Z 04004KT 5000 HZ NSC 10/M06 Q1016 NOS
<FONT FACE="Monospace,Courier">OEJN 140800Z 12006KT 9999 FEW040 31/09 Q1012 NOSI
i mean should not the result been without a redundancy in the 2 field DOC_ID by (1 ) and NAME by ( Metar_taf)???
Forms [32 Bit] Version 9.0.2.9.0 , oracle JInitiator: 1.3.1.9, WebUtil 1.0.2(Beta), window , IE 8
Thank you.
