1 CREATE OR REPLACE PACKAGE ClassPackage AS
2 PROCEDURE AddStudent(p_StudentID IN students.id%TYPE,
3 p_departments IN classes.departments%TYPE,
4 p_Course IN classes.course%TYPE);
5 PROCEDURE AddStudent(p_FirstName IN students.first_name%TYPE,
6 p_LastName IN students.last_name%TYPE,
7 p_departments IN classes.departments%TYPE,
8 p_Course IN classes.course%TYPE);
9 END ClassPackage;
/ --中间加一个'/'开始执行CREATE PACKAGE命令 10 CREATE OR REPLACE PACKAGE BODY ClassPackage AS
11 PROCEDURE AddStudent(p_StudentID IN students.id%TYPE,
12 p_departments IN classes.departments%TYPE,
13 p_Course IN classes.course%TYPE) IS
14 BEGIN
...
...
/ --执行CREATE PACKAGE BODY命令
2 PROCEDURE AddStudent(p_StudentID IN students.id%TYPE,
3 p_departments IN classes.departments%TYPE,
4 p_Course IN classes.course%TYPE);
5 PROCEDURE AddStudent(p_FirstName IN students.first_name%TYPE,
6 p_LastName IN students.last_name%TYPE,
7 p_departments IN classes.departments%TYPE,
8 p_Course IN classes.course%TYPE);
9 END ClassPackage;
/ --中间加一个'/'开始执行CREATE PACKAGE命令 10 CREATE OR REPLACE PACKAGE BODY ClassPackage AS
11 PROCEDURE AddStudent(p_StudentID IN students.id%TYPE,
12 p_departments IN classes.departments%TYPE,
13 p_Course IN classes.course%TYPE) IS
14 BEGIN
...
...
/ --执行CREATE PACKAGE BODY命令
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货