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

解决方案 »

  1.   

    create or replace procedure addbook (
    @book_id book.book_id%type,
    @book_name book.book_name%type,
    @price book.price%type

    asbegin
    insert into book(
    book_id,
    book_name)
    values
    (
    @book_id,
    @book_name,
    @price);
    end
      

  2.   

    create or replace procedure addbook (
    book_id book.book_id%type,
    book_name book.book_name%type,
    price book.price%type

    asbegin
    insert into book(
    book_id,
    book_name)
    values
    (
    book_id,
    book_name,
    price);
    end
      

  3.   

    insert into book(
    book_id,
    book_name)
    少写了字段.!