CREATE PROCEDURE UserInfo_Insert1
@UserName char(16),
@FullName varchar(32),
@Password varchar(50),
@Level smallint,
@AreaCode char(12),
@Status bit,
@OrgName varchar(50),
@OfficeTel char(20),
@Fax char(20),
@MobileTel char(12),
@Email varchar(50),
@Address varchar(100),
@Postalcode char(10),
@Re varchar(200),
@BuildTime datetime,
@LastLogTime datetime,
@LastLogIP char(20)
AS
DECLARE @UserID VARCHAR(50)
SET @UserID = RTRIM(LTRIM(@UserName))
BEGIN TRANSACTION
INSERT INTO UserInfo([UserName], [FullName], [Password],[Level],[AreaCode],[Status], [OrgName], [OfficeTel], [Fax], [MobileTel], [Email], [Address], [Postalcode],[Re], [BuildTime], [LastLogTime], [LastLogIP]) VALUES(@UserName, @FullName, @Password, @Level,@AreaCode, @Status,@OrgName, @OfficeTel, @Fax, @MobileTel, @Email, @Address, @Postalcode, @Re, @BuildTime, @LastLogTime, @LastLogIP)
INSERT INTO SysGroupMembership(GroupID,UserName) VALUES(1,@Username)
IF @@ERROR <> 0
ROLLBACK TRAN
ELSE
COMMIT TRANGO
解决方案 »
- 函数返回long类型或者出参 out long 类型
- Oracle 小问题请大侠们帮忙啊
- 如何把excel中的数据导入到oracle数据库中
- 求oracle 8.1.7 for linux
- 一个关于存储过程的问题,只能执行一半就跳出了!不知道为什么?大家帮忙看看!
- aix 下用G++编译ORACLE9I下的OCI程序。(AIX 5。3)安装ORACLE过程没出一点错误。
- oracle问题急需解决!在线等!
- 按创建时间查找某一年份的数据,怎么写查询语句?
- 我用Repository Administration Utility 安装一个Repository的 instance,结果报错,请问如何解决?!!
- 数据库字符集(ZHS16GBK)和客户端字符集(2%)是不同的,字符集转化可能会造成不可预期的后果
- 请教在不同的库中对比数据的方法,在线等...
- 请教怎么计算一个表的占用空间?
UserName char,
FullName varchar2,
Password varchar2,
Level smallint,
AreaCode char,
Status number,
OrgName varchar2,
OfficeTel char,
Fax char,
MobileTel char,
Email varchar2,
Address varchar2,
Postalcode char,
Re varchar2,
BuildTime date,
LastLogTime date,
LastLogIP char )
AS
UserID varchar22(50) ;
begin
UserID := RTRIM(LTRIM(UserName)) ;
INSERT INTO UserInfo(UserName,
FullName,
Password,Level,
AreaCode,Status,
OrgName, OfficeTel,
Fax,
MobileTel,
Email,
Address,
Postalcode,
Re,
BuildTime,
LastLogTime, LastLogIP)
VALUES(UserName,
FullName,
Password,
Level,AreaCode,
Status,
OrgName,
OfficeTel,
Fax,
MobileTel,
Email, Address,
Postalcode,
Re,
BuildTime,
LastLogTime,
LastLogIP);
INSERT INTO SysGroupMembership(GroupID,UserName)
VALUES(1,Username) ;
IF SQL%ROWCOUNT = 0 then
ROLLBACK ;
ELSE
COMMIT ;
end if
END;
ROLLBACK ;
ELSE
COMMIT ;
end if 这一块有问题,去掉就OK了,能不能再帮忙修改一下?
我已经弄好了