编译过程失效提示“PLS-00103 encountered the symbol "OGMPZKFD"”
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;
END;
ogmpzkfd := c_gmf;
COMMIT;
ROLLBACK;
END p_goodsmfprice;

该如何解决呢？求高手解答

[解决办法]
语法不对了：
“ogmpzkfd := c_gmf;”上面那行的“END;”别要了，而且，COMMIT后又ROLLBACK，看你是想做异常处理，但是不是这样做的。你试试：

SQL code

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;