才发现 pls_integer是整数，而integer不是

chengccy2010

2293782717 发表于 2017-9-28 16:43
哪天的每日一题？

尝试一下就知道了

1. SQL> set serveroutput on
   
2. SQL>
   
3. SQL> create or replace procedure ppp(num in integer)
   
4.   2  is l integer:=num;
   
5.   3  begin
   
6.   4  dbms_output.put_line(l);
   
7.   5  end;
   
8.   6  /
   
9. 
   
10. Procedure created
    
11. 
    
12. SQL> exec ppp(1.2);
    
13. 1.2
    
14. PL/SQL procedure successfully completed
    
15. 
    
16. SQL>
    
17. SQL> create or replace procedure ppp(num in pls_integer)
    
18.   2  is l integer:=num;
    
19.   3  begin
    
20.   4  dbms_output.put_line(l);
    
21.   5  end;
    
22.   6  /
    
23. 
    
24. Procedure created
    
25. 
    
26. SQL> exec ppp(1.2);
    
27. 1
    
28. PL/SQL procedure successfully completed
    

复制代码

newkid

http://www.itpub.net/thread-1814916-1-1.html