UC知道oracle存储过程问题
来源：百度知道 编辑：UC知道 时间：2024/05/09 02:05:20
CREATE OR REPLACE PACKAGE pkg_AddDiary
AS
TYPE myrctype IS REF CURSOR;
PROCEDURE Proc_AddDiary (BlogIDi in number, Subjecti in NVarChar2, DiaryContenti in long, p_rc OUT myrctype);
END pkg_AddDiary;
/
CREATE OR REPLACE PACKAGE BODY pkg_AddDiary
AS
PROCEDURE Proc_AddDiary (BlogIDi in number, Subjecti in NVarChar2, DiaryContenti in long, p_rc OUT myrctype)
IS
ReleaseDatei DATE;
BEGIN
ReleaseDatei:=to_date(SYSDATE，'MM-DD-YYYY HH24:MI:SS');
update user_info set LastUpdateDate:=ReleaseDatei where UserID=BlogIDi;
insert into diary_info(BlogID,Subject,DiaryContent,ReleaseDate) values(BlogIDi,Subjecti,DiaryContenti,ReleaseDatei)
OPEN p_rc FOR
select * from diary_info where DiaryID=(select max(DiaryID) from diary_info);
END Proc_AddDiary;
COMMIT TRANSACTION
请问这段代码有问题吗？它的提示是这样的
AS
TYPE myrctype IS REF CURSOR;
PROCEDURE Proc_AddDiary (BlogIDi in number, Subjecti in NVarChar2, DiaryContenti in long, p_rc OUT myrctype);
END pkg_AddDiary;
/
CREATE OR REPLACE PACKAGE BODY pkg_AddDiary
AS
PROCEDURE Proc_AddDiary (BlogIDi in number, Subjecti in NVarChar2, DiaryContenti in long, p_rc OUT myrctype)
IS
ReleaseDatei DATE;
BEGIN
ReleaseDatei:=to_date(SYSDATE，'MM-DD-YYYY HH24:MI:SS');
update user_info set LastUpdateDate:=ReleaseDatei where UserID=BlogIDi;
insert into diary_info(BlogID,Subject,DiaryContent,ReleaseDate) values(BlogIDi,Subjecti,DiaryContenti,ReleaseDatei)
OPEN p_rc FOR
select * from diary_info where DiaryID=(select max(DiaryID) from diary_info);
END Proc_AddDiary;
COMMIT TRANSACTION
请问这段代码有问题吗？它的提示是这样的
1、PACKAGE BODY 没有结束end语句；
2、ReleaseDatei:=to_date(SYSDATE，'MM-DD-YYYY HH24:MI:SS');
SYSDATE本身就是date类型，无需再转换
3、你创建存储过程Proc_AddDiary后，创建PACKAGE pkg_AddDiary 即可，无需创建PACKAGE BODY 了