5 Replies Latest reply on Jun 27, 2017 11:47 AM by Gaz in Oz

    JSON code not showing the data in PLSQL using apex_json.get_varchar2

    OraDev

      Dear All,

       

      I am using Oracle Database 12c and trying to run the following code :

       

       

       

      DECLARE  
      s varchar2(32767) := '{"items":[{"descr":"data01","w_master_d_code":4033},{"descr":"data02 ","w_master_d_code":4034}]}';  
      BEGIN  
      apex_json.parse(s);  
      dbms_output.put_line('descr is '||apex_json.get_varchar2(p_path => 'items[%].descr'));  
      END;  
      /  
      
      

       

      but it is showing null , what is the problem please.