Hi All,
Given a directly executed procedure has a possibility of executing code which will cause an error, how do I suppress the error message?
I still want to trap the error code, but I want to totally handle everything that ensues from the error point.
Example:
create procedure trial_date_cast(
a_string varchar(40) not null not default
)
as declare
int_date ingresdate not null not default;
begin
int_date = date(:a_string);
return iierrornumber;
end;
If I then execute procedure trial_date_cast(a_string = 'not a date')\g
Executing . . .
E_US10CE 'not a date' is not a valid date/time value.
Ideas?
Martin Bowes
