Forum Stats

  • 3,874,734 Users
  • 2,266,768 Discussions
  • 7,911,961 Comments

Discussions

Convert any user-defined type/collection to JSON

user4377404
user4377404 Member Posts: 6 Green Ribbon
edited Oct 17, 2018 9:15AM in Database Ideas - Ideas

Basically the same as you can convert any object/cursor to XMLTYPE. JSON_OBJECT only supports simple types, not the user defined ones.

Sven W.user4377404Emad Al-MousaAlex Lamar-OracleMike KutzPeter HraškoEvandro Lima-OracleGregVBEDEgaverillPeterGsdstuber
12 votes

Active · Last Updated

Comments

  • Sven W.
    Sven W. Member Posts: 10,559 Gold Crown

    Useful.

    Not only for sql object types, but for plsql collections as well. In the past I have written my own collection2json conversion functions. Often to help with debugging issues for complex objects/collections. => Convert it into json and write it to the trace or error log.

  • user4377404
    user4377404 Member Posts: 6 Green Ribbon

    Useful.

    Not only for sql object types, but for plsql collections as well. In the past I have written my own collection2json conversion functions. Often to help with debugging issues for complex objects/collections. => Convert it into json and write it to the trace or error log.

    Edited title to include "collection".