17,140
社区成员




create or replace procedure insertPerson(pname in varchar2,page in number) as
begin
insert into persons values (person_seq.nextVal,pname,page);
end insertPerson;
SQL> create or replace procedure insertPerson(pname in varchar2,page in number)
as
2 begin
3 insert into persons values (person_seq.nextVal,pname,page);
4 end insertPerson;
5 /
警告: 创建的过程带有编译错误。
SQL>
C:\Documents and Settings\Administrator>sqlplus
SQL*Plus: Release 9.2.0.1.0 - Production on 星期二 12月 1 10:38:51 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
请输入用户名: scott
请输入口令:
create or replace procedure insertPerson(pname in varchar2,page in number) as
begin
insert into persons values (person_seq.nextVal,pname,page);
end insertPerson;
/
begin
insertPerson(参数,参数);
end;
/