Re: Whats the error here
On Thu, 13 Nov 1997, S.Sathish wrote:
} create procedure proc_tmp ()
} returning int;
} define x int;
} on exception in (-206)
} create table proc_tab (col1 char(15));
} insert into proc_tab values ("1000");
} end exception with resume
} insert into proc_tab values ("1000")
} let x = select count(*) from proc_tab;
} ^ 201: A syntax error has occurred.
SELECT COUNT(*) INTO x FROM proc_tab;
Untested, but plausible.
} return x;
} end procedure
Yours,
Jonathan Leffler (johnl@informix.com) #include <witticism.h>