Hello Group,

I have an exception I am raising within a PSQL block, using the 1.5
feature to replace the static message with a more detailed message.

eg

if (somecondition = 'T') then
begin
exception EMyException 'Somecondition was already met';
end

I also wanted to include some additional details in the exception
message to make it easier for the user to diagnose and fix.

exception EMyException 'Somecondition was met by ' ||
OtherEmployeeName || ' on ' || dateofinterest;

What is the maximum length that string can be before it overflows? I
am happy to make use of substring to guarantee it doesn't, but I don't
know what to restrict it to.

Thanks

Adam