Hi,
I'm not sure why this problem is occurring, but it appears that the '%rowtype' isn't working very well with the max function. If you fetch into an explicitely declared variable it works:
declare
cursor csr is select max(mon_dt7) max_m from table1;
lrtvar char(7);
begin
open csr;
fetch...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.