如何在PLSQL Developer中调用存储过程
建立名为Test1的存储过程, 代码如下:
CREATE OR REPLACE PROCEDURE Test1(DATA IN VARCHAR2,RES OUT VARCHAR2)
AS C_BOM_NO VARCHAR2(25);
BEGIN
SELECT BOM_NO INTO C_BOM_NO FROM SFIS1.C_BOM_KEYPART_T
WHERE BOM_NO = DATA AND ROWNUM = 1;
RES := 'OK';
EXCEPTION
WHEN OTHERS THEN
RES := ' NO BOM';
END;
如何在PLSQL Developer中调试呢?