CRM On Demand - Web Services Integration (MOSC)

MOSC Banner

How to handle long tag elements (30 char+) in Oracle for web services call ?

We are trying to make a web service call from Oracle to update the element "allow-inv-no-backing-doc-from-connect" in Coupa. We can send either true or false for this element. But as the element length is more than 30 character, we are not able to generate the JSON using the below code:

OPEN l_cursor FOR
        SELECT cur_rec.name "name",
               cur_rec.name "display-name",
               cur_rec.supplier_number "number",
               cur_rec.status "status",
               cur_rec.po_method "po-method",
               cur_rec.po_change_method "po-change-method",
               cur_rec.withholding "withholding",
               cur_rec.invoice_matching_level "invoice-matching-level",
               cur_rec.po_email "po-email",
               cur_rec.duns "duns",

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center