SQL> create or replace procedure add_books(
2 isbn_in varchar2,barcode_id_in varchar2,title_in varchar2,
3 author_in varchar2,summary_in varchar2,data_published_in date,
4 page_count_in number)
5 as
6 begin
7 if isbn_in is null
8 then
9 raise value_error;
10 end if;
11 insert into books (isbn,title,summary,author,date_published,page_count)
12 values(isbn_in,title_in,summary_in,author_in,date_published_in,page_count_in);
13 if barcode_id_in is not null
14 then
15 insert into book_copies(barcode_id,isbn) values(barcode_id_in,isbn_in);
16 end if;
17 end;
18 /
警告: 创建的过程带有编译错误。
SQL> show error
PROCEDURE ADD_BOOKS 出现错误:
LINE/COL ERROR
-------- -----------------------------------------------------------------
11/1 PL/SQL: SQL Statement ignored
12/46 PL/SQL: ORA-00984: 列在此处不允许
SQL> desc books
名称 是否为空? 类型
----------------------------------------- -------- ----------------------------
ISBN NOT NULL VARCHAR2(13)
TITLE VARCHAR2(200)
SUMMARY VARCHAR2(2000)
AUTHOR VARCHAR2(200)
DATE_PUBLISHED DATE
PAGE_COUNT NUMBER
请大侠们帮忙，错在哪里？怎么解决，