Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> is select * in web form not allowed
gurus,
i have the ff: code w/ work fine in client server but not in web
cursor cus_cur is
select * from customers;
x cus_cur%rowtype;
begin
open cus_cur;
fetch cus_cur into x;
close cus_cur;
end;
in the web, when it execute the fetch an error ora-0093 inconsistent data types. but when i changed the cursor stmt into
select cust_code,name from customers the fetch execute successfully.
is this a bug in 8i?
Best regards,
Grace Lim
Suy Sing Comm'l Corp.
(063)-02-247-41-34
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: grace lim INET: mglim_at_softhome.net Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Thu Feb 22 2001 - 22:30:04 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).