This function retrieves the detailed SQLERRM of the last exception raised.
Know Details About SQLERRM Function
This function retrieves the detailed SQLERRM of the last exception raised.
Syntax
UTL_HTTP.get_detailed_sqlerrm
RETURN VARCHAR2;
EXAMPLE:
-----------------------
1. EXECUTE THE BELOW ANONYMOUS BLOCK
DECLARE
l_request UTL_HTTP.req;
BEGIN
l_request := UTL_HTTP.begin_request ('http://www.some_company.com');
END;
2. NOW RUN THE BELOW SQL COMMAND
select utl_http.get_detailed_sqlerrm from dual
Syntax
UTL_HTTP.get_detailed_sqlerrm
RETURN VARCHAR2;
EXAMPLE:
-----------------------
1. EXECUTE THE BELOW ANONYMOUS BLOCK
DECLARE
l_request UTL_HTTP.req;
BEGIN
l_request := UTL_HTTP.begin_request ('http://www.some_company.com');
END;
2. NOW RUN THE BELOW SQL COMMAND
select utl_http.get_detailed_sqlerrm from dual
No comments:
Post a Comment