Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Native Web Services 4000 character limit for JSON Data

MannyJayJul 25 2013 — edited Jul 25 2013

Dear Experts,

I have a requirement to have the JSON data as out type or PlSql Procedure which has varchar2 type.

When my JSON converted data is being sent by this variable, still after reaching 4000 characters, I could see the output in Toad console.

But when I try from WSDL URL, it fails with below error:

<Message>Error occurred in XML processing</Message>

</OracleError>

<Message>PL/SQL: numeric or value error</Message>

</OracleError>

Hence I thought I could use XMLTYPE, but it's supported only for XML formatted file. As per my requirement I have to send the JSON data thru' plsql which is more than 4000+. Please help on this.

Thanks,

Mani

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 22 2013

Added on Jul 25 2013

#performance-availability, #xml-db

2 comments

902 views