Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Netsuite SOAP Webservice is returning -length of input buffer is smaller than amount requested error
When attempting to call a SOAP web service from oracle PLSQL and return the result in a XML Type variable
the following error occurs.
ERROR
-----------------------
ORA-22921: length of input buffer is smaller than amount requested
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Use code below:
DBMS_OUTPUT.put_line('l_vendor_envelope =' || l_envelope);
BEGIN
l_xml := APEX_WEB_SERVICE.make_request(
p_url => 'https://'||x_netsuite_account||'.suitetalk.api.netsuite.com/services/NetSuitePort_2020_1',
p_action => 'search',
p_envelope => l_envelope
);
EXCEPTION WHEN OTHERS THEN
x_status := 'E';
Tagged:
0