How to call a stored procedure in Oracle

One, through the PLS block to call the stored procedure;

Declare

P_dzno VARCHAR2 (50);

P_vchtype VARCHAR2 (50);

P_productclass VARCHAR2 (50);

P_dptcode VARCHAR2 (50);

Begin

p_vchtype:= ' MP ';

p_productclass:= ' 03 ';

p_dptcode:= ' 206 ';

PRODDATA.product_dz_proc.pd_getdzno (P_dzno,p_vchtype,p_productclass,p_dptcode);

Dbms_output.put_line (P_dzno);

End

This article is from the "Small Li Guangzhi Blog" blog, please be sure to keep this source http://6817977.blog.51cto.com/6807977/1597119

How to call a stored procedure in Oracle