Oracle9i创建存储过程出错,
代码如下:
1.创建表
CREATE TABLE HK_PERSON (
EntityID VARCHAR(50) PRIMARY KEY,
Name VARCHAR(50) ,
Age VARCHAR(50) ,
Description VARCHAR(255),
Timestamp TIMESTAMP NOT NULL,
ClientModifyDt TIMESTAMP DEFAULT sysdate NOT NULL ,
ModifyDt TIMESTAMP DEFAULT sysdate NOT NULL ,
CreateDt TIMESTAMP DEFAULT sysdate NOT NULL ,
ActiveFlg Integer DEFAULT (1) NOT NULL
)
2.创建存储过程
CREATE OR REPLACE PROCEDURE HK_PROC_UI_PERSON
(
v_EntityID VARCHAR,
v_Name VARCHAR,
v_Age VARCHAR,
v_Description VARCHAR,
v_Timestamp TIMESTAMP,
v_ClientModifyDt TIMESTAMP,
v_CreateDt TIMESTAMP,
v_ActiveFlg INTEGER
)
IS
BEGIN
INSERT INTO HK_PERSON(
EntityID,
Name,
Age,
Description,
Timestamp,
ClientModifyDt,
ModifyDt,
CreateDt,
ActiveFlg
)
VALUES
(
