Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> is select * in web form not allowed

is select * in web form not allowed

From: grace lim <mglim_at_softhome.net>
Date: Thu, 22 Feb 2001 20:30:04 -0800
Message-ID: <F001.002BB562.20010222202528@fatcity.com>

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-L

(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Feb 22 2001 - 22:30:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US