Oracle Solution for Error ora-19011

Solution for Oracle Error ORA-19011

ORA-19011: Character string buffer too small

What triggered the Error:

The string result asked for is too big to return back

What should we do to fix it:

Get the result as a lob instead