dcsimg
Results 1 to 2 of 2

Thread: [RESOLVED] ORA-00904: : invalid identifier

  1. #1

    Thread Starter
    Addicted Member a-a06's Avatar
    Join Date
    Dec 2007
    Location
    P.H.
    Posts
    147

    Resolved [RESOLVED] ORA-00904: : invalid identifier

    Hi Guys,

    Hoping someone would be able to help me on this. The below code is running perfectly fine on other regions of our application but not in dev.

    I had someone checked on this and he told me that the issue is on DBMS_LOB.SUBSTR of the query but he doesn't know how to fix it. I just can't understand why it's fine in other environment with same database configurations. Hoping for some suggestions. Thanks!

    Error: ORA-00904: : invalid identifier

    Code:
    SELECT DISTINCT (SELECT POD_NAME FROM PO_DOMAINSERVICECONFIG) --"INFA Domain"
          ,PO_IDOBJ_2.POI_SECURITYDOMAIN    --"Security Domain"
          ,PO_IDOBJ_2.POI_NAME              --"User"
          ,CASE PO_IDOBJ_3.POI_DISABLE
               WHEN 0 THEN 'Enabled'
               WHEN 1 THEN 'Disabled'
           END                              --"Status"
          ,PO_USERINFO.POU_FULLNAME         --"User Full Name"
          ,DBMS_LOB.SUBSTR (PO_USERINFO.POU_DESCRIPTION, 4000, 1 ) --"User Description"
          ,PO_USERINFO.POU_EMAIL            --"Email"
          ,PO_USERINFO.POU_PHONE            --"Phone"
      FROM PO_IDOBJ PO_IDOBJ_2
          ,PO_IDOBJ PO_IDOBJ_3
          ,PO_USERINFO
    WHERE PO_IDOBJ_3.POI_NAME = PO_IDOBJ_2.POI_NAME
       AND PO_IDOBJ_3.PSI_DISCRIMINATOR = 'USER'
       AND PO_USERINFO.PSU_OPID = PO_IDOBJ_3.POI_USERINFO
    ORDER
        BY UPPER(PO_IDOBJ_2.POI_NAME)

  2. #2

    Thread Starter
    Addicted Member a-a06's Avatar
    Join Date
    Dec 2007
    Location
    P.H.
    Posts
    147

    Re: ORA-00904: : invalid identifier

    This was resolved.

    DBMS_LOB package was missing in SYS database for unknown reason. Had DBA reinstall it and it worked fine.

Posting Permissions

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



Featured


Click Here to Expand Forum to Full Width