Question

有关oracle数据库的问题

create or replace
FUNCTION FUNC_GET_BOOK
(
ISBN IN VARCHAR2
, TITLE OUT VARCHAR2
, SHELF_LETTER OUT VARCHAR2
, CALL_NUMBER OUT NUMBER
, NO_OF_COPIES OUT NUMBER
) RETURN NUMBER IS
BEGIN
v_NEW_ISBN := &a_NEW_ISBN;
IF (NEW_ISBN = ISBN)THEN
dbms_output.put_line(BOOK.title, BOOK.shelf_letter, BOOK.call_number, BOOK.no_of_copies);
RETURN BOOK.BOOK_ID;
ELSE
RETURN -1;
END IF;
END FUNC_GET_BOOK;
请问这个应该怎么改 那位大神帮忙看看

Answer 1

把你的FUNCTION 改成PROCEDURE
你这个应该建成存储过程，而不是FUNCTION
create or replace PROCEDURE FUNC_GET_BOOK 。。。

Answer 2

函数只能返回一个值...你想返回4个列是不对的
create or replace
FUNCTION FUNC_GET_BOOK
(
v_ISBN IN VARCHAR2
, result_output OUT VARCHAR2 )
IS
v_sql varchar2(200);
BEGIN
v_sql :='select BOOK.title||BOOK.shelf_letter||BOOK.call_number||BOOK.no_of_copies into result_output from book where ISBN = ' & v_ISBN;
excute immediate (v_sql);
RETURN result_output;
END ;