ORDS, SODA & JSON in the Database

DECLARE

l\_data CLOB;  

l\_empname VARCHAR2 (50);  

l\_division  VARCHAR2 (25);  

l\_url VARCHAR2 (1000) :='http://ip:port/PersonalInfoServic/personalinfocontroller?action=GETEMPDETFOREMPLOYEECODE'   

;

BEGIN

l\_data := apex\_web\_service.make\_rest\_request(  

    p\_url => l\_url,  

    p\_http\_method => 'GET'  

);  

WITH json\_tab AS  

(  

    SELECT l\_data FROM dual  

)  

SELECT l\_data, division  

    INTO :P5\_EMPNAME,:P5\_DIVN  

EXCEPTION WHEN no_data_found THEN

:P5\_EMPNAME := '';  

:P5\_DIVN := '';  

END;

Sir ,using this code i can able to call the Full API in the :P5_EMPNAME…but i need division in the :P5_DIVN what should i do ?