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