create or replace procedure des_update(
goodid in varchar2(20)) as
goods_name varchar2(80);
goods_specs varchar2(80);
begin
select goods_enname into goods_name from goods_dict when goods_id= goodid;
select specs into goods_specs from goods_dict when goods_id= goodid;
update contract_detail set description= goods_name+ goods_specs when goods_id= goodid;
end des_update;
/
请高手指点一下。
goodid in varchar2(20)) as
goods_name varchar2(80);
goods_specs varchar2(80);
begin
select goods_enname into goods_name from goods_dict when goods_id= goodid;
select specs into goods_specs from goods_dict when goods_id= goodid;
update contract_detail set description= goods_name+ goods_specs when goods_id= goodid;
end des_update;
/
请高手指点一下。
解决方案 »
- 求救:ora不能正常启动(linux下)
- 能不能推荐下oracle经典教程,绝对经典的
- 关于数据库的循环嵌套查询
- 客户端版本兼容问题
- 怎么说dataForDate不是过程和未定义
- 讨教表格的存储方法.
- 两个问题,太急了,100分
- 如何同步oracle9i的数据库与powerdesign中的物理模型?
- 高分求一条sql语句,谢谢,在线等!!!
- 在客户端用plsqldevelop备份服务器端的oracle的数据库问题(在线等待
- 有关于jdbc,java,oracle的编程问题
- 如果imp做full导入的时候用ignore=y参数,会不会对数据字典的表进行insert??造成数据字典的表的数据造成重复
2、as后要一个declare
3、保证select goods_enname into goods_name from goods_dict when goods_id= goodid;
select specs into goods_specs from goods_dict when goods_id= goodid;
只有一条记录,虽然没有编译错误,如果返回多行,执行则会异常
goodid in varchar2)
as
goods_name varchar2(80);
goods_specs varchar2(80);
begin
select goods_enname into goods_name from goods_dict when goods_id= goodid;
select specs into goods_specs from goods_dict when goods_id= goodid;
update contract_detail set description=
goods_name ||'/'|| goods_specs --如果是字符型可以用||合并
when goods_id= goodid;
end des_update;
------------------
对了那个declare可以不要
goodid in varchar2)
as
goods_name varchar2(80);
goods_specs varchar2(80);
begin
select goods_enname into goods_name from goods_dict when goods_id= goodid;
select specs into goods_specs from goods_dict when goods_id= goodid;
update contract_detail set description= goods_name||'/'||goods_specs when goods_id= goodid;
end des_update;
还是编译错误吗!!!!有调试工具吗?不知道错哪里啊!!!!
....
你语句里面的when是什么?
应该是where吧
show err查看错误信息