同意楼上 补充源码 1:包 CREATE OR REPLACE PACKAGE ADD_USERS IS PROCEDURE UsersAdd (UserId IN NUMBER, UserName IN VARCHAR2 , Pwd IN VARCHAR2, Department IN VARCHAR2, Re IN VARCHAR2); END ADD_USERS;2:包体CREATE OR REPLACE PACKAGE BODY ADD_USERS IS PROCEDURE UsersAdd (UserId IN NUMBER, UserName IN VARCHAR2 , Pwd IN VARCHAR2, Department IN VARCHAR2, Re IN VARCHAR2) AS BEGIN INSERT INTO www_users VALUES(UserId,UserName,Pwd,Department,Re); END; 以上已经代码经过测试
2 包体 CREATE OR REPLACE PACKAGE BODY ADD_USERS IS PROCEDURE UsersAdd (UserId IN NUMBER, UserName IN VARCHAR2 , Pwd IN VARCHAR2, Department IN VARCHAR2, Re IN VARCHAR2) AS BEGIN INSERT INTO www_users VALUES(UserId,UserName,Pwd,Department,Re); END; END ADD_USERS;
补充源码
1:包
CREATE OR REPLACE PACKAGE ADD_USERS
IS
PROCEDURE UsersAdd
(UserId IN NUMBER,
UserName IN VARCHAR2 ,
Pwd IN VARCHAR2,
Department IN VARCHAR2,
Re IN VARCHAR2);
END ADD_USERS;2:包体CREATE OR REPLACE PACKAGE BODY ADD_USERS
IS
PROCEDURE UsersAdd
(UserId IN NUMBER,
UserName IN VARCHAR2 ,
Pwd IN VARCHAR2,
Department IN VARCHAR2,
Re IN VARCHAR2)
AS
BEGIN
INSERT INTO www_users
VALUES(UserId,UserName,Pwd,Department,Re);
END;
以上已经代码经过测试
CREATE OR REPLACE PACKAGE BODY ADD_USERS
IS
PROCEDURE UsersAdd
(UserId IN NUMBER,
UserName IN VARCHAR2 ,
Pwd IN VARCHAR2,
Department IN VARCHAR2,
Re IN VARCHAR2)
AS
BEGIN
INSERT INTO www_users
VALUES(UserId,UserName,Pwd,Department,Re);
END;
END ADD_USERS;