create or replace procedure UpdateDemarcateFileIsActive
declarations IDNum in varchar2,
declarations Name in varchar2
as
begin
update demarcatefile set isactive='0' where name=Name
update demarcatefile set isactive='1' where id=IDNum
end;
警告:创建的存储过程带有编译错误.
该存储过程该怎么写呢?
还有执行的时候该怎么执行?
还请各位同仁多多指教.非常感谢.
declarations IDNum in varchar2,
declarations Name in varchar2
as
begin
update demarcatefile set isactive='0' where name=Name
update demarcatefile set isactive='1' where id=IDNum
end;
警告:创建的存储过程带有编译错误.
该存储过程该怎么写呢?
还有执行的时候该怎么执行?
还请各位同仁多多指教.非常感谢.
解决方案 »
- OracleDBConsoleorcl无法启动 错误997 重叠i/o操作在进行中
- orcale超过最大连接数的问题
- 关于触发器的问题?
- SQL-02145: 动态描述符无效
- 请教高手,关于execute immediate
- 关于SQL优化中的In和Exists
- 一个关于ORACLE PL/SQL语句写法的问题?(急)
- 请教,如何提高文本导入临时表的速度?????????(在线)
- 帮帮忙,我的IMP怎么做都出错!
- char 和 varchar2 有什么区别?
- &&&&&求助啊..SQL SERVER中的一个带游标和递归的存储过程.j要改成能在ORACLE中能运行的
- pl/sql 写一段从数据库曲值生成txt或csv文件的程序,我写的为什么不对??
CREATE OR REPLACE PROCEDURE UPDATEDEMARCATEFILEISACTIVE(NAMEX IN VARCHAR2,
IDNUM IN VARCHAR2) IS
BEGIN
UPDATE DEMARCATEFILE SET ISACTIVE = '0' WHERE NAME = NAMEX;
UPDATE DEMARCATEFILE SET ISACTIVE = '1' WHERE ID = IDNUM;
END;
/调用方法:
BEGIN
UPDATEDEMARCATEFILEISACTIVE('abc', '123');
END;
/
create or replace procedure UpdateDemarcateFileIsActive
(IDNum in varchar2,
Name_in in varchar2)
as
begin
update demarcatefile set isactive='0' where name=Name_in;
update demarcatefile set isactive='1' where id=IDNum;commit;
end;
改成下面看看..
create or replace procedure UpdateDemarcateFileIsActive(IDNum in varchar2,
Name in varchar2) is
begin
update demarcatefile set isactive = '0' where name = Name;
update demarcatefile set isactive = '1' where id = IDNum;
commit;
end;
begin
UpdateDemarcateFileIsActive('1','2');
end;