CREATE OR REPLACE PROCEDURE KJTSSOX.XH
as
declare v_num_1 NUMBER(8);
v_num_2 NUMBER(8);BEGIN
set v_num_1 = (select XH from XW);
set v_num_1 = (select FBJH from XW_FJ);
NULL;
END;
as
declare v_num_1 NUMBER(8);
v_num_2 NUMBER(8);BEGIN
set v_num_1 = (select XH from XW);
set v_num_1 = (select FBJH from XW_FJ);
NULL;
END;
解决方案 »
- VS2010连接Oracle,碰到一些困难了,大家帮忙看下吧
- 快来帮我,感谢,关于ORACLE sql developer乱码问题!
- 请问JDBC 连ORCACLE 11G 的代码
- oracle 分页 排序
- 小散点分,多了个小裤衩
- 触发器的问题.我写的这个触发器老是说编译有错,不明白什么意思,请指教!谢
- 访问ORACLE73 ODBC数据源出错!急急急!!!
- Oracle中可不可以用E/R图显示各表间关系(就像ERWin或Rose建模显示的那样)
- 求一句update的写法
- 英雄们:为何资料档案库创建成功,服务启动却报错?
- Oracle如何调用其他用户下的存储过程?
- 帮忙解决下这个orcale存储过程!!!!!!!!!!!!
as
v_num_1 NUMBER(8);
v_num_2 NUMBER(8); BEGIN
select XH into v_num_1 from XW;
select FBJH into v_num_2 from XW_FJ;
END; 不过这种PROCEDURE毫无意义.
而且XW和XW_FJ里面的记录大于一条都会报错
as
declare v_num_1 NUMBER(8);
v_num_2 NUMBER(8); BEGIN
set v_num_1 = (select XH from XW where ...);
set v_num_2 = (select FBJH from XW_FJ where ...);
END;
最好是加上条件:v_num_1 是一个变量
select XH from XW 是一个集合
楼主一定要注意这个问题
as/is下面的就是声明部分,不要再写declar了
CREATE OR REPLACE PROCEDURE KJTSSOX.XH
as v_num_1 NUMBER(8);
v_num_2 NUMBER(8); BEGIN
set v_num_1 = (select XH from XW where ...);
set v_num_2 = (select FBJH from XW_FJ where ...);
END;
as
BEGIN
declare v_num_1 NUMBER(8);
v_num_2 NUMBER(8); BEGIN
set v_num_1 = (select XH from XW);
set v_num_1 = (select FBJH from XW_FJ);
NULL;
END;
END;
少了BEGIN,END;