读书人

创建的过程带有编译错误:SP2-0310: 无

发布时间: 2014-01-28 21:21:35 作者: rapoo

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

        

读书人网 >oracle

热点推荐