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
=====================================================