Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006
    Posts
    2

    Unanswered: ORA-00904:Invalid Column Name In Oracle Object Type

    Hello,

    I have created an Oracle Object type like this...

    CREATE OR REPLACE TYPE ObjType_ClmTempTable AS OBJECT
    (
    clm_number NUMBER(11),
    clm_cov_desc VARCHAR2(70),
    clm_obj_desc VARCHAR2(70),
    clm_liab_lmt VARCHAR2(70),
    clm_dsp_self_excess VARCHAR2(200),
    clm_status_desc VARCHAR2(70),
    clm_per_in_charge_code VARCHAR2(400),
    clm_reserve NUMBER(13),
    clm_invld_reasons VARCHAR2(255),
    clm_type_inj_desc VARCHAR2(100),
    clm_dmgd_obj VARCHAR2(200),
    clm_created_by VARCHAR2(141),
    clm_created_date DATE,
    clm_pic_assigned_date DATE,
    clm_cov_number NUMBER(9),
    clm_type VARCHAR2(15),
    clm_damage_type VARCHAR2(15),
    clm_status_code VARCHAR2(4),
    clm_payment_status_type VARCHAR2(10)
    )
    /
    CREATE OR REPLACE TYPE tbltype_Claim_Details AS TABLE OF ObjType_ClmTempTable

    Sometimes when I am firing the following Query it gives the error "ORA-00904:Invalid Column Name"

    SELECT clm_number,
    clm_cov_desc,
    clm_obj_desc,
    clm_liab_lmt,
    clm_dsp_self_excess,
    clm_status_desc,
    clm_per_in_charge_code,
    clm_reserve,
    clm_invld_reasons,
    clm_type_inj_desc,
    clm_dmgd_obj,
    clm_created_by,
    clm_created_date,
    clm_pic_assigned_date,
    clm_cov_number,
    clm_type,
    clm_damage_type,
    clm_status_code,
    clm_payment_status_type
    FROM THE (
    SELECT CAST (ltbl_clmtemptable AS tbltype_claim_details)
    FROM DUAL)
    ORDER BY clm_number

    I found that last column "clm_payment_status_type" gives error. But after sometime again the error disappears automatically.

    Yesterday in our Production DB, I found this error and when we restart the DB, the error disappears automatically.


    Can anybody help me out, why this is happening???

    Thanks in advance

    Regards
    Rasmi

  2. #2
    Join Date
    Sep 2004
    Posts
    60
    Can you provide any associated message with error !

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •