日期:2014-05-17  浏览次数:20822 次

这个存储过程为什么错
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