oracle預存程序的調用

標籤：arch   creat   color   style   st3   code   span   儲存   div   

/*例1*/CREATE OR REPLACE PROCEDURE test1 IS BEGIN  NULL; END; begintest1();end;/*例2*/CREATE OR REPLACE PROCEDURE test2( p1 IN nvarchar2 )as BEGIN  dbms_output.put_line(p1);END; declaremsg NVARCHAR2(2000);begintest2(p1 => ‘肖建‘);end;/*例3*/CREATE OR REPLACE PROCEDURE test3(       p1 IN nvarchar2 ,        p2 out nvarchar2 )IS BEGIN  p2 := p1;END; declaremsg NVARCHAR2(2000);begintest3(p1 => ‘xxx‘,p2 =>msg);dbms_output.put_line(msg);end;

 

oracle預存程序的調用