`

Invoke a function in TOAD

阅读更多
Michael told me how to write a snippet to run a function in TOAD.

DECLARE
   r    NUMBER;
   v    VARCHAR2 (10);
   v2   VARCHAR2 (200);
BEGIN
   v := '';
   v2 := '';
   r :=
      pkg_np0006_port_req.insert_npr
                    ('000028451234',    
                     '000004022200132', 
                     'NWTC080000005',   
                     '19302',           
                     'TEL',             
                     'TC',              
                     '1',               
                     '20080108',        
                     '13:00',           
                     '15:00',           
                     '',                
                     'MR Cheung Kwok',  
                     'E3911483',        
                     'ONP',             
                     '0',               
                     'DATA',            
                     'BPN08000002-01',  
                     '',                
                     '0',               
                     v,                 
                     v2                 
                    );
dbms_output.put_line(v);
dbms_output.put_line(v2);
dbms_output.put_line(r);						
END;

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics