ORACLE 创建过程:
CREATE OR REPLACE PROCEDURE upd_table(v_name NVARCHAR2) //参数名称v_name ,参数类型NVARCHAR2
is
e_no_row EXCEPTION; //声明异常
BEGIN
UPDATE tablename SET NAME='123' WHERE NAME='456' ;
IF SQL%NOTFOUND THEN //语句异常
RAISE e_no_row; //抛出异常
END IF;
EXCEPTION
WHEN e_no_row THEN
raise_application_error(-20004,'订单不存在');
END upd_table;
PL/SQL 块:
DECLARE
v_name VARCHAR2(200); //参数名称v_name ,参数类型NVARCHAR2
BEGIN
SELECT bookname INTO v_name FORM tableName //查询结果映射到 v_name
WHERE ID=&no; //no 为自定义字段名 可任意, ID为表字段
dbms_output.out_line(v_name); //输出
END;