[maxandsoftParticipant]

isn’t present that impossible

[maxandsoftParticipant]

select parsing in apex_collection

FUNCTION PARSE_FIELDS(p_sql VARCHAR2, p_region_id IN varchar2)
  RETURN CLOB
  IS
    t_cur    PLS_INTEGER;
    t_cols   DBMS_SQL.desc_tab2;
    t_ncols  PLS_INTEGER;
    t_dummy  PLS_INTEGER;
    t_d      DATE;
    t_n      NUMBER;
    t_v      VARCHAR2(32767);
    t_json   CLOB;--VARCHAR2(32767);
    t_object CLOB;--VARCHAR2(32767);
  BEGIN
    t_cur := DBMS_SQL.open_cursor;
    DBMS_SQL.parse(t_cur, p_sql, DBMS_SQL.native);
    DBMS_SQL.describe_columns2(t_cur, t_ncols, t_cols);
    APEX_COLLECTION.CREATE_OR_TRUNCATE_COLLECTION(p_collection_name => p_region_id);
    FOR i IN 1 .. t_ncols
    LOOP
      CASE
        WHEN t_cols(i).col_type IN (2, 100, 101) THEN DBMS_SQL.define_column(t_cur, i, t_n);
          APEX_COLLECTION.ADD_MEMBER(p_collection_name => p_region_id, p_c001 => t_cols(i).col_name, p_c002 => 'number');    
        WHEN t_cols(i).col_type IN (12, 180, 181, 231) THEN DBMS_SQL.define_column(t_cur, i, t_d);
          APEX_COLLECTION.ADD_MEMBER(p_collection_name => p_region_id, p_c001 => t_cols(i).col_name, p_c002 => 'date');   
        ELSE DBMS_SQL.define_column(t_cur, i, t_v, 4000);
          APEX_COLLECTION.ADD_MEMBER(p_collection_name => p_region_id, p_c001 => t_cols(i).col_name, p_c002 => 'string');   
      END CASE;
    END LOOP;
  
    DBMS_SQL.close_cursor(t_cur);
   
    return 'true';
END;

[maxandsoftParticipant]

excuse for my Russian

[maxandsoftParticipant]

— AP_JSON_TEST
DECLARE
  v_sql VARCHAR2 (4000);
BEGIN
  — Note: This query is meant to return no rows
  v_sql := ‘SELECT ename FROM emp WHERE 1 = 2’;
  �
  — Print JSON result set
  apex_util.json_from_sql (v_sql);
END;

JSON and JQWidgets is friends

[maxandsoftParticipant]

[maxandsoftParticipant]

I try it

[Author]

Posts