你写的这句好像也有问题吧?用showerror返回PLS-00103:出现符号"("在需要下列之一时：:=),defaul

Question

你写的这句好像也有问题吧?用show error 返回PLS-00103:出现符号 "("在需要下列之一时：:= ) ,defaul

Answer 1

try this one.remove the length definition
CREATE OR REPLACE PROCEDURE SP_GETDAY
( dt IN CHAR,
dtDay OUT CHAR)
IS
BEGIN
SELECT to_char(to_date(dt,'yyyyMMdd'),'day')
INTO dtDay
FROM dual;
END;