17,377
社区成员
发帖
与我相关
我的任务
分享
CREATE OR REPLACE PROCEDURE p_goodsmfprice(vgdid IN VARCHAR2,
vmfid IN VARCHAR2,
ogmpzkfd OUT VARCHAR2)
AS
c_gmf dbusrHQ.goodsmfprice@hdqt_db.gmpzkfd%rowtype;
BEGIN
SELECT distinct gmpzkfd
INTO c_gmf
FROM dbusrHQ.goodsmfprice@hdqt_db
where gmpmfid = vmfid
and gmpgdid = vgdid;
ogmpzkfd := c_gmf;
COMMIT;
exception when others then
ROLLBACK;
END p_goodsmfprice;