是不是选取某几个字段时,必须用select ...into ...,存储过程才有效?
nnlyc 2004-07-13 10:15:58 如题,Oracle8i,今天发现选取几个字段时,仅仅是select ...from...的话,总是Invalid,加了into 后就valid,怎么会这样呢?比如:
(plog_name in system.reg_member.login_name%TYPE,
ptruename out varchar2,
pjob out varchar2,
pemail out varchar2,
pphone out varchar2,
pfax out varchar2,
pm_phone out varchar2,
ppost out varchar2,
pcompname out varchar2,
pcompweb out varchar2,
pmaintrade out varchar2,
psale out varchar2,
pbuy out varchar2,
pcity out varchar2,
pstreet out varchar2
)
is
begin
select true_name,e_mail,phone,city_address,street_address,
fax,mobile_phone,post_code,company_name,job,main_trade,
buy_product,sale_product,company_homepage
into ptruename,pemail,pphone,pcity,pstreet,pfax,pm_phone,
ppost,pcompname,pjob,pmaintrade,pbuy,psale,pcompweb
from system.reg_member
where login_name=plog_name;
end get_companyinfo;
如果不写into的话就不行,就算是最简单的没有in、out参数的select * from table也是无效,郁闷:(
另外,如何取得这些out参数的值赋值给textbox?(asp.net,c#)