Maximum Response size

Hi, I’m relatively new to Postman and an Web API calls. I’ve created a Oracle REST WS which I’m calling successfully from Postman. The response is the output from a scheduled job, I’ve found however as soon as the output size reaches 32766 in size, I get the following error:

ORA-06502: PL/SQL: numeric or value error

So my question is whether there are any ways to increase the size of the response that can be handled? I’ve changed the Max response size to 100MB but it made no difference!

How are large files handled in Postman? Maybe I need to return an attached file from the WS call? Can anyone point me in the right direction?

Thank you

1 Like

You can change the response size to 0 MBs in case you want to receive files of Any Size. I had written a thorough answer to this on this SO thread: Error: Maximum response size reached get method Json object along with file part (Spring boot rest api) - Stack Overflow

1 Like