奇怪的參數傳遞問題,高手請盡,在線等待 ..................

Question

PROCEDURE          TX_LABOR_STATION001  
     (  v_STATION_NO    IN      varchar2,  
         v_STATION_IP  IN  varchar2,  
         Result  OUT  varchar2)  
     IS  
   v_STATION_ID    number:=  0;  
     v_COUNT    number:=  0;  
     v_RESULT  varchar2(100):='';  
   BEGIN  
     --判斷是否有該站別v_STTION_ID....................................................................  
     SELECT  STATION_ID    into    v_STATION_ID  
                                                             FROM  LBM.CARD_STATIONS  
                       --                                    WHERE  STATION_NO='0'  
             --                          AND  STATION_IP='172.18.10.84';                          
                                               WHERE  STATION_NO=v_STATION_NO      
                                       AND  STATION_IP=v_STATION_IP  ;  
                                         
                                     if  v_STATION_ID  >0  
                                     then  
                                     Result:='查無該站!';  
                                     ELSE  
                                     Result:='OK';  
                           
                                     end  if;  
   
 
END;  --  Procedure  
數據庫里有紀錄,但是我用參數傳進去怎麼也查不到,懷疑參數沒有傳進去,尋求大俠幫助,謝謝

Answer 1

老兄你写的太乱了吧,把SQL语句用括号括好,条理就清楚了,在And的时候.再试试.