create or replace package igkk is
TYPE v_ref_stu IS REF CURSOR;
PROCEDURE ighack(co_no IN INTEGER,v_stu OUT v_ref_stu);
end igkk;create or replace package body igkk is
PROCEDURE ighack(co_no IN INTEGER,v_stu OUT v_ref_stu)
AS
BEGIN
OPEN v_stu FOR SELECT * FROM student_info s WHERE s.class_no=co_no;
END ighack;
end igkk;DECLARE
v_stu igkk.v_ref_stu;
BEGIN
igkk.ighack(200001,v_stu);
END报下需的错误
pls-00103:出现符号"end-of-file"在需要下列之一时:
;<an identifier>
<a double-quoted delimited-identifer>
符号";"被替换为"end-of-file"后继续但我在.net是可以正常显示数据的
TYPE v_ref_stu IS REF CURSOR;
PROCEDURE ighack(co_no IN INTEGER,v_stu OUT v_ref_stu);
end igkk;create or replace package body igkk is
PROCEDURE ighack(co_no IN INTEGER,v_stu OUT v_ref_stu)
AS
BEGIN
OPEN v_stu FOR SELECT * FROM student_info s WHERE s.class_no=co_no;
END ighack;
end igkk;DECLARE
v_stu igkk.v_ref_stu;
BEGIN
igkk.ighack(200001,v_stu);
END报下需的错误
pls-00103:出现符号"end-of-file"在需要下列之一时:
;<an identifier>
<a double-quoted delimited-identifer>
符号";"被替换为"end-of-file"后继续但我在.net是可以正常显示数据的
; <an identifier>
<a double-quoted delimited-identifier> delete exists prior
<a single-quoted SQL string>
符号 ";" 被替换为 "end-of-file" 后继续。
请在该存储过程的最后一个END的后面加上一个';'。