这个存储过程为什么错
create or replace procedure addbook as
(
@book_id book.book_id%type,
@book_name book.book_name%type,
@price book.price%type
)
begin
insert into book(
book_id,
book_name)
values
(
@book_id,
@book_name,
@price);
end;
警告: 创建的过程带有编译错误。
SP2-0310: 无法打开文件 "book_id.sql "
SP2-0310: 无法打开文件 "book_name.sql "
SP2-0310: 无法打开文件 "price.sql "
刚学ORACLE比较菜,所用为ORACLE 10G
------解决方案--------------------create or replace procedure addbook (
book_id book.book_id%type,
book_name book.book_name%type,
price book.price%type
)
as
begin
insert into book(
book_id,
book_name)
values
(
book_id,
book_name,
price);
end