select TRADE_TYPE,PHONE,USER_NAME,HAND_MONEY,SNMCCORDER
into TradeType,PhoneCode,UserName,HandMoney,SnmcCorde
from TRADE_INF where POSID = PosId;
就是说这句返回了不止一行记录
into TradeType,PhoneCode,UserName,HandMoney,SnmcCorde
from TRADE_INF where POSID = PosId;
就是说这句返回了不止一行记录
posid为主键
(p_PosId in char,.....select TRADE_TYPE,PHONE,USER_NAME,HAND_MONEY,SNMCCORDER
into TradeType,PhoneCode,UserName,HandMoney,SnmcCorde
from TRADE_INF where POSID = p_PosId;