view里字段的datatype为undefined 已解决

smonkey0

CREATE OR REPLACE FORCE VIEW "INVENTORY_RCG"."REAGENT_MOLTABLE_VIEW"
("CDBREGNO", "CTAB", "MOLWEIGHT", "COMPOUND_ID", "ID", "REG_DATE", "MOLFORMULA", "SECUR_LABEL")
AS
SELECT /*+ first_rows */
C."CDBREGNO",C."COMPOUND_ID",C."ID",C."REG_DATE",C."CTAB",C."MOLFORMULA",C."MOLWEIGHT",C."STRUCTURE_ID",C."STRUCTURE_NAME",C."ROLE_ID",C."MONOISOTOPIC_MOLWEIGHT", rc.secur_label
FROM   REAGENT_MOLTABLE C, REAGENT_SECUR_LABEL RC
WHERE  C.CDBREGNO = RC.CDBREGNO AND
         ( RC.SECUR_LABEL IS NULL OR
           EXISTS ( SELECT 1
                    FROM   AQUIRE.ORCL_USER U
                    WHERE  U.ORCL_USER = USER AND
                           U.secur_label IS NOT NULL AND
        utl_raw.bit_and(RC.secur_label,U.secur_label) <> HEXTORAW('0000000000000000')) )
WITH READ ONLY;


创建这个view 提示执行完毕, 但带有警告。（郁闷的是show errors却没任何信息。。。）创建后所有字段的datatype都是undefined.请达人帮助。

[ 本帖最后由 smonkey0 于 2008-2-29 11:26 编辑 ]