Çë½Ì¹ØÓÚoracleµÄ×Ô¶¨Ò庯ÊýµÄÎÊÌâ

create or replace function GetWorkBeginTime()
  return date is
  myDate    date;
begin
  myDate := trunc(sysdate-1)+8/24;
  return myDate;
end;

дÁ˸öº¯Êý£¬¿ÉÊDZàÒ벻ͨ¹ý£ºCompilation errors for FUNCTION REPORTER.GETWORKBEGINTIME

Error: PLS-00103: ³öÏÖ·ûºÅ ")"ÔÚÐèÒªÏÂÁÐ֮һʱ£º
        <an identifier>
          <a double-quoted delimited-identifier> current
Line: 1
Text: create or replace function GetWorkBeginTime()

Ôõô½â¾ö£¿Çë¸ßÊÖÖ¸µã¡£

---

ÄãÊÇÔÚÄÄÀïÖ´Ðеİ¡£¬ÎÒµÄÔÚplsqlÀïÃæÖ´ÐУ¬ÍêÈ«³É¹¦µÄ¡£

---

SQL code:
create or replace function GetWorkBeginTime()
return date is
myDate date;
begin
myDate := trunc(sysdate-1)+8/24;
return myDate;
end GetWorkBeginTime;


ÕâÑùÊÔÊÔ¿´

---

¼ÓÉϲÎÊýÊÔÊÔ:

create or replace function GetWorkBeginTime1(out date)
  return date is
  myDate    date;
begin
  myDate := trunc(sysdate-1)+8/24;
  return myDate;
end;

---

ÕâÑùÊÔÊÔ£º
create or replace function GetWorkBeginTime
  return date is
  myDate    date;