为何不拿分

[tjq_tang]

第一步创建对象类型NU_FILEINFO_TYPE,执行成功

CREATE OR REPLACE TYPE NU_FILEINFO_TYPE AS OBJECT(
"NU_FILE_ID" INTEGER,
"NU_FILE_NAME" VARCHAR2(100),
"NU_FILE_SIZE" NUMBER,
"NU_FILE_SOURCE" VARCHAR2(200),
"NU_FILE_POSTFIX" VARCHAR2(10),
"NU_FILE_CONTEXT" BLOB,
"NU_FILE_INTRODUCE" VARCHAR2(2000),
"NU_FILE_UPLOADTIME" DATE,
"NU_FILE_MODIFYTIME" DATE,
"NU_FILE_DOWNLOADTIMES" INTEGER,
"NU_FILE_ESTIMATE" VARCHAR2(100)
);
第二步创建对象表NU_FILEINFO (执行成功)
CREATE TABLE NU_FILEINFO OF NU_FILEINFO_TYPE(
"NU_FILE_ID" NOT NULL PRIMARY KEY
);
但是,第三步创建关于该表的过程InsertToNU_FILEINFO时程序出错,望大家帮帮我这落难之人,帮我调试这个过程.

CREATE OR REPLACE PROCEDURE InsertToNU_FILEINFO(p_FileID IN INTEGER,
p_FileName IN VARCHAR2(100),
p_FileSize IN NUMBER(10),
p_FileSource IN VARCHAR2(200),
p_FilePostfix IN VARCHAR2(10),
p_FileContext IN BLOB,
p_FileIntroduce IN VARCHAR2(2000),
p_FileUpLoadTime IN DATA,
p_FileModifyTime IN DATA,
p_FileDownLoadTimes IN INTEGER,
P_FileEstimate IN VARCHAR2(1000))
IS
BEGIN
INSERT INTO NU_FILEINFO VALUES(NU_FILEINFO_TYPE(p_FileID,
p_FileName,
p_FileSize,
p_FileSource,
p_FilePostfix,
p_FileContext,
p_FileIntroduce,
p_FileUpLoadTime,
p_FileModifyTime,
p_FileDownLoadTimes,
P_FileEstimate
);
END;

[developer2002]

存储过程的参数类型不可以限定精度。如：varchar2，number,char。
这些精度都可以从实参中获得

[bzszp]

改成 col1 tbname.rolna%type这种形式就可以了。

[jaderiver]

BEGIN
INSERT INTO NU_FILEINFO
(NU_FILEINFO_TYPE(
NU_FILE_ID,
NU_FILE_NAME,
NU_FILE_SIZE,
NU_FILE_SOURCE,
NU_FILE_POSTFIX,
NU_FILE_CONTEXT,
NU_FILE_INTRODUCE,
NU_FILE_UPLOADTIME,
NU_FILE_MODIFYTIME,
NU_FILE_DOWNLOADTIMES,
NU_FILE_ESTIMATE )
VALUES(
p_FileID,
p_FileName,
p_FileSize,
p_FileSource,
p_FilePostfix,
p_FileContext,
p_FileIntroduce,
p_FileUpLoadTime,
p_FileModifyTime,
p_FileDownLoadTimes,
P_FileEstimate );
END;