oracle portal fetch bug? or limitation
From: jm <john_20_28_2000_at_yahoo.com>
Date: 5 Dec 2001 14:20:18 -0800
Message-ID: <c67e4bdd.0112051420.4e765178_at_posting.google.com>
I have a fetch statement. I hope this is enough of the code:
...
end;
You must assume that I have done all the variable correctly even though they are not shown. It is mainly the fetch. This program works great until I add a twelfth variable to the fetch. It does not matter what the data is, null, or populated, but when I put any variable over eleven into the fetch I get an error. Of course, I cannot see the error, because it only said "not found."
Date: 5 Dec 2001 14:20:18 -0800
Message-ID: <c67e4bdd.0112051420.4e765178_at_posting.google.com>
I have a fetch statement. I hope this is enough of the code:
declare
type cur_typ is ref cursor; sql_stmt varchar2(1000); c cur_typ;
...
begin
...
open c for sql_stmt;
loop
fetch c into name, race, sex, dob...up to the eleven on twelve it dies no matter what the data or column is;
if c%FOUND then
htp.p('rows found: '||c%rowcount);
end if;
exit when c%notfound;
htp.p('<td>'||name||'</td>');
htp.p('<td>'||race||'</td>');
htp.p('<td>'||sex||'</td>');
htp.p('<td>'||dob||'</td>');
end loop;
...
end;
You must assume that I have done all the variable correctly even though they are not shown. It is mainly the fetch. This program works great until I add a twelfth variable to the fetch. It does not matter what the data is, null, or populated, but when I put any variable over eleven into the fetch I get an error. Of course, I cannot see the error, because it only said "not found."
Hope this made some sense. Received on Wed Dec 05 2001 - 23:20:18 CET