SQL & PL/SQL

Hi All,

i am trying to make a call to a soap webservice but facing the below error:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

i tried through SQL Developer also but the same issue

the following query i am using

declare
payload clob;
return_payload XMLTYPE;
BEGIN
payload:= to_clob(‘----SOAP Payload -----’);

return_payload:= apex_web_service.make_request(
p_url =>'url',
p_envelope => payload,
p_username => 'username',
p_password => 'password' );

DBMS_OUTPUT.put_line('return_payload= ' || return_payload.getClobVal());

END;

this query worked when i passed a small payload so i think the issue is related to size only. Can anybody help me with this

Thanks in advance