这个sqlserver的存储过程如何改成ORACLE的？？？

2005-04-10 07:35:12 156 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

树莓派4B安装 ubuntu20.04 & VNC远程桌面 & 安装ROS noetic 树莓派4B安装ubuntu20.04 & VNC远程桌面1、安装ubuntu方式1：下载Imager文件。方式2：下载镜像文件。2、查询树莓派 IP 地址3、使用ssh远程登录树莓派4、更新源地址5、更新6、安装桌面环境7、允许root登陆8、登陆远程桌面9、设置中文 1、安装ubuntu 方式1：下载Imager文件。... 阅读详情

REATE PROCEDURE departmentadmin
@parentdepartmentID int,
@departmentname varchar(40),
@tel1 varchar(30),
@tel2 varchar(30),
@fax varchar(30),
@ispublic bit,
@departmentid int OUTPUT,
@IsStepPass bit
AS
DECLARE @id int
select @id=departmentid from departments where parentdepartmentid=@parentdepartmentID and
departmentname=@departmentname
if @id is null

begin

insert into departments (parentdepartmentid,departmentname,tel1,tel2,fax,ispublic,IsStepPass)
values( @parentdepartmentID, @departmentname,@tel1, @tel2 ,@fax,@ispublic,@IsStepPass)
set @departmentid=@@identity

end

else
begin
set @departmentid=-1
end
GO

...全文

Android P HAL层添加HIDL实例（详细实现步骤） Android P HAL层添加HIDL实例本文将介绍如何在P OS上添加HIDL实例，简单增加seLinux策略使得可以在system_service调用测试，并用模拟器emulator验证。调用过程为 APP->TestManager->TestService->ITast.hal 文章目录Android P HAL层添加HIDL实例实现过程一、hardware部分1... 阅读详情

fleamboy

Oracle 17,133 成员 55,258 内容

+ 关注 + 加入社区

切换为时间正序

dragonwzw 2005-04-11

打赏
举报

create or replace PROCEDURE departmentadmin(
parentdepartmentID in number,
departmentname in varchar2,
tel1 in varchar2,
tel2 in varchar2,
fax in varchar2,
ispublic in number,
departmentid OUTPUT number,
IsStepPass in number
)
AS
id number
BEGIN
select departmentid INTO id from departments
where parentdepartmentid=parentdepartmentID
and departmentname=departmentname;

if id is null then

insert into departments (parentdepartmentid,departmentname,tel1,tel2,fax,ispublic,IsStepPass)
values( parentdepartmentID, departmentname,tel1, tel2 ,fax,ispublic,IsStepPass);

departmentid:=identity;

else
departmentid:=-1
end if;

END departmentadmin;

liuyi8903 2005-04-11

打赏
举报

你试一下.可能还有些小小的改动

CREATE OR REPLACE PROCEDURE DEPARTMENTADMIN(PARENTDEPARTMENTID INT,
DEPARTMENTNAME VARCHAR2,
TEL1 VARCHAR2,
TEL2 VARCHAR2,
FAX VARCHAR2,
ISPUBLIC VARCHAR2,
DEPARTMENTID INT OUTPUT,
ISSTEPPASS VARCHAR2) IS
ID INTEGER := 0;
BEGIN
SELECT DEPARTMENTID
INTO ID
FROM DEPARTMENTS
WHERE PARENTDEPARTMENTID = PARENTDEPARTMENTID
AND DEPARTMENTNAME = DEPARTMENTNAME;
IF ID IS NULL THEN
INSERT INTO DEPARTMENTS
(PARENTDEPARTMENTID,
DEPARTMENTNAME,
TEL1,
TEL2,
FAX,
ISPUBLIC,
ISSTEPPASS)
VALUES
(PARENTDEPARTMENTID,
DEPARTMENTNAME,
TEL1,
TEL2,
FAX,
ISPUBLIC,
ISSTEPPASS);
DEPARTMENTID := IDENTITY;
COMMIT;
ELSE
DEPARTMENTID := -1;
END IF;

EXCEPTION
WHEN NO_DATA_FOUND THEN
RAISE_APPLICATION_ERROR(ERRNO, ERRMSG);
END DEPARTMENTADMIN;

ern 2005-04-10

打赏
举报

看看oracle基础的pl/sql吧，这个很简单的
begin后的第一段就是一个select into，不过记得框在begin exception end里面，那么为空的情况就是NO_DATA_FOUND异常了，第二段代码就可以放在exception里

这个sqlserver的存储过程如何改成ORACLE的？？？

相关推荐