Parsing json using webservice url
firstly you should install json parsing package. you will find it at http://sourceforge.net/projects/pljson/ or https://github.com/pljson/pljson declare l_http_request UTL_HTTP.req; l_http_response UTL_HTTP.resp; l_response_text CLOB; acd VARCHAR2(32767); buf VARCHAR2(32767); l_list json_list; empno number; ename VARCHAR2(100); job VARCHAR2(100); mgr number; hiredate VARCHAR2(100); sal number; comm varchar2(200); deptno number; obj json; --get json from url begin l_http_request := UTL_HTTP.begin_request('http://127.0.0.1:9000/ords/anuj/anuj/emp/', 'GET' , 'HTTP/1.1' ); l_http_response := UTL_HTTP.get_response(l_http_request); B...