Search This Blog

Sunday, July 7, 2019

Know Details About SQLERRM Function

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

Restrict File Upload by File Type in Oracle Apex

If you want to restrict file upload by file type/extension/format you can follow the below steps.  Goto File Browser Item --> Advanced --...