Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What is the datatype to store the value of variable of UTL_HTTP.resp

fatehcis-JavaNetJan 30 2013 — edited Jan 30 2013
Hello,
I am using Oracle 11g R2 SOE.

I have table Called SMS consists of two columns (TEXT , RESPONSE) to store the value of variable of type UTL_HTTP.resp

the datatype of TEXT column is varchar2.
What should be the datatype of the column RESPONSE that is supposed to store the value of a variable of type UTL_HTTP.resp ????

Please see the following example if it was not clear;
Declare
  l_url2 SMS.RESPONSE%TYPE;
  l_http_request2   UTL_HTTP.req;
  l_http_response2  UTL_HTTP.resp;
begin
  l_http_request2  := UTL_HTTP.begin_request(l_url2);
  l_http_response2 := UTL_HTTP.get_response(l_http_request2);

  insert into SMS (text,response) values (l_url2,l_http_response2);

  UTL_HTTP.end_response(l_http_response2);

end;
Regards,
Fateh
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 27 2013
Added on Jan 30 2013
1 comment
527 views