consult about insert CLOB data into tha table in my database

25 pts.
Tags:
procedure output testing

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)???

 

Thank you.

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following