Some errors at compile-time Oracle stored procedures

ERROR:PLS-00201: Must indicate identifier ' DATETIME '

Line:45

TEXT:AA datetime,

-------------------------

No datetime types in Oracle

===================================================

Error: PLS-00103: 出现符号 "("在需要下列之一时：
　　　　:= . ) , @ %
　　　　　default character
　　　 符号 ":=" 被替换为 "(" 后继续。
Line: 5
Text: P_APP_NUMBER VARCHAR2(11),

----------------------------

Parameter types are not allowed in stored procedures and function definitions Varchar2,varchar,char length (VARCHAR2 (11) is wrong, (VARCHAR2 is correct)

======================================================

ERROR:PLS-00323: subroutine or cursor ' Insert_patrol_plan ' has been described in the package description and must be in the package body

To define it.

Line:8

Text:p_patrol_type VARCHAR2,

-----------------------------------------------------

Package in the body of the Declaration and the implementation of the parameter type or parameter number or parameter order is inconsistent, or in the body without corresponding implementation

=====================================================