oracle 执行存储过程返回值
http://lwl0606.cmszs.com/archives/excel-vba-string-function.html
先建好表,然后写带输出参数的存储过程
CREATE OR REPLACE PROCEDURE "MES"."MES_GETKEY" (KName IN
VARCHAR2,KValue OUT VARCHAR2) AS
BEGIN
select KeyValue into KValue from MES_SYSTEMKEY where Keyname=KName;
end MES_GetKey;
VARCHAR2,KValue OUT VARCHAR2) AS
BEGIN
select KeyValue into KValue from MES_SYSTEMKEY where Keyname=KName;
end MES_GetKey;
然后运行
var c varchar2(50);
exec MES.MES_GETKEY('PRODUCE_NO',:c)
PRINT c;
就可以看到输出结果了,如果用的是 PL/SQL Developer,在命令窗口运行即可