Scribd Logo
Upload

Welcome to Scribd!

  • 32 views

    Generating JSON in APEX 5.0 - Explorer UK

    Uploaded by

    Ayad Oracle
    How to generate JSON using APEX.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Generating JSON in APEX 5.0 - Explorer UK

    Uploaded by

    Ayad Oracle
    32 views7 pages
    How to generate JSON using APEX.

    Original Title

    Generating JSON in APEX 5.0 – Explorer UK

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    How to generate JSON using APEX.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    32 views7 pages

    Generating JSON in APEX 5.0 - Explorer UK

    Uploaded by

    Ayad Oracle
    How to generate JSON using APEX.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 7

    Home Company Case Studies Oracle Services Now Hiring

    APEX APEX 5.0 HOW TO


    Search …
    Generatin
    g JON in  Categorie
    APEX 5.0 
    APEX (314)
    APEX 18 (3)
    APEX 5.0 (33)
    APEX 5.1 (12)
    Data Visualization (19)
    E-Business Suite (1)
    How to (79)
    News (6)
    Generating  Oracle Forms (15)

    JON in  ORDS (6)


    Security (4)

    APEX 5.0 AUTONOMOUS (2)


    Autonomous (2)
    Chatbot (1)
    In a previou log I 
    Company News (4)
    outlined how with APEX 5.0 
    Database (1)
    ou can now ue the  Engineered Systems (7)
    APEX_JON package to  Hybrid & Multi Cloud (2)
    pare JON repone in  Licensing (9)
    our APEX application. For  Oracle Cloud (18)
    thi log I will how ou  Oracle Reports (1)
    Reporting (3)
    how ea it i to generate 
    our own JON uing jut 
    the in-uilt APEX 
    Categorie
    package.

    If ou want to pa data  Select Category


    from our application to a 
    we ervice, chance are 
    ou will need to do thi 
    uing JON. A an APEX 
    Recent Pot
    developer it i extremel 
    Can I generated PDFs from APEX in
    likel that ou are 
    the Always Free Oracle Cloud?
    pro cient with QL, and 
    thi i all ou need to 
    Time is running out: Do you have
    generate a JON 
    plan for your Oracle Reports?
    repreentation of our 
    data.

    Tag
    I created a tet 
    application to 
    Multi Cloud New features OAuth2 ODA
    demontrate jut how ea 
    ORACLE Oracle Cloud Oracle Data
    it i. In the image elow 
    ou can ee that I have 
    Visualization Oracle Forms
    Oracle Licensing Oracle Reports
    created two text area, 
    one for our QL quer 
    ORDS Outsource PaaS Page Designer
    PDF PL/PDF PL/SQL Plug-ins Plugin
    and one for the JON 
    repreentation of the 
    Raspberry Pi reporting
    reult. I have entered an  Resource RESTful Rich
    text editor SAM Save SE2 Search
    extremel imple quer 
    into m text area for thi 
    Security Session shuttle Standard
    Support Team
    Edition Style
    example ut ou would 
    Development Tech17 Template
    likel ue tatic querie and 
    ind variale in our 
    Universal Theme upgrade
    code to avoid an QL  Upgrading Validation Values Version Control

    injection attempt. Vulnerabilities Zip le

    Preing the ‘Generate’ 
    utton umit the page 
    and  re the following 
    PL/QL code:

    We are opening a curor 
    aed on the QL entered 
    in our  rt text area and 
    uing the 
    APEX_JON.WRITE 
    procedure to generate the 
    JON reult. The other 
    procedure ued to 
    initialize and open the 
    CLOB are important for thi 
    demontration to work and 
    can e read up on in the 
    APEX_JON package 
    documentation.

    Once we have generated 
    the JON reult we can 
    ue the 
    APEX_JON.GET_CLOB_OUTPUT 
    function to et the value of 
    our JON text area, a 
    hown elow:

    And a ea a that, we 
    have correctl formatted 
    JON data generated 
    directl from the 
    dataae. The quer ou 
    ue to generate the JON 
    can e a lot more 
    complicated in a real 
    world cenario, allowing 
    complex JON dataet to 
    e generated.

    Ovioul thi wa jut a 
    hort demontration of 
    how the data can e 
    generated and the reall 
    ueful application of thi 
    package lie in the ue of 
    APEX a a we ervice 
    itelf. Thi require a lightl 
    di erent approach to 
    generating the JON a 
    we need to include a 
    JON header rather than 
    jut the data itelf.

    In the near future I will 
    ring together the idea 
    from thi log and m 
    previou log (Paring 
    JON in APEX 5.0) to 
    create a imple we 
    ervice which create and 
    conume JON uing 
    APEX and ORD.

    Colin
    Archer
    Contributor

    Senior Oracle APEX


    Development
    Consultant
    Explorer UK
    , LTD

    Colin i a enior 
    Development 
    Conultant at 
    Explorer with 20 
    ear experience 
    of anali, 
    deign and 
    development of 
    epoke Oracle 
    application for 
    a wide variet of 
    uine 
    function. 
    Building on hi 
    previou 
    experience of 
    Form and 
    PL/QL he i now 
    focuing on 
    developing high 
    qualit  t for 
    purpoe olution 
    uing APEX.

    TAG: # APEX 5.0

    # JON


    The Bene t…  Breaking ou…

    Quick 
    Tweets by Link
    Addre: Wira  @Explorerukltd

    Buine Park,  Aout 
    Explorer UK Ltd
    Wet Park, Ring  Retweeted
    U
    Road, Leed,  Blog
    Gavin Bell
    L16 6EB @GavBellDev Cae 
    Is time running tudie
    Phone: 0113  Career
    out?
    289 9470 Contact 
    #OracleForms
    Mail: U
    12.2.1.4 was the
    Privac 
    first release since
    Polic
    #OracleReports
      was deprecated.
    Do you have a
    plan for what to
    do with your
    reports? Check

    Copright © 2019 Explorer UK Ltd. 

    You might also like