SQL & PL/SQL

Hi All,

I am using oracle wallet manager for sending XML response and collecting XML response from webserver. I am having URL details in CLOB variable but when i use it in UTL_URL.escape function it gives me error ORA-06502: PL/SQL: numeric or value error.

Is there any way we can pass CLOB to generate URL and get CLOB in return.I am using CLOB as length is more than VARCHAR2.

Can you suggest any other way to generate URL to send to UTL_HTTP.begin_request function to get response.

Below is portion of code i am using...

l_esc_url varchar2(32767);
l_outxml CLOB; -- This contain XML
l_message VARCHAR2(32767);

UTL_HTTP.SET_WALLET(l_wallet_path,l_wallet_password);

l_esc_url :=l_message|| utl_url.escape(l_outxml , TRUE, 'UTF-8' );

l_req := Utl_Http.begin_request (l_esc_url, 'GET');
l_resp := Utl_Http.get_response (r => l_req);


Please suggest if there is alternate way to do this.

Thanks
Rinkesh