在SQL*PLUS里面写,例如:CREATE PROCEDURE credit (acc_no IN NUMBER, amount IN NUMBER) AS
BEGIN
UPDATE accounts
SET balance = balance + amount
WHERE account_id = acc_no;
EXCEPTION
WHEN OTHERS THEN
NULL;
END;
BEGIN
UPDATE accounts
SET balance = balance + amount
WHERE account_id = acc_no;
EXCEPTION
WHEN OTHERS THEN
NULL;
END;
调试可用pl/sql developer工具作调试.