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