APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01445: cannot select ROWID from, or sample, a join view without a key..

Alexandra RobinAug 23 2011 — edited Aug 25 2011

Created a view, trying to use it in a tabular form. No luck. TIA, as always.

CREATE OR REPLACE FORCE VIEW  "ECR_APPROVE_VW" ("ECR_FORM_ID", "JOB_DESC_ID", "ECRNO", "STATUS", "REQUEST_DT", "STATUS_DT", "REQUEST_APPRVL", "APPROVED", "ECR_APPRVL_COMMENT", "JOB_DESC", "USER_NAME") AS 
  select    
"DOC_ECR_FORM"."ECR_FORM_ID" AS "ECR_FORM_ID",
"DOC_ECR_FORM"."JOB_DESC_ID" AS "JOB_DESC_ID",
"DOC_ECR_FORM"."ECRNO" AS "ECRNO",
"DOC_ECR_FORM"."STATUS" AS "STATUS",
"DOC_ECR_FORM"."REQUEST_DT" AS "REQUEST_DT",
"DOC_ECR_FORM"."STATUS_DT" AS "STATUS_DT",
"DOC_ECR_FORM"."REQUEST_APPRVL" AS "REQUEST_APPRVL",
"DOC_ECR_FORM"."APPROVED" AS "APPROVED",
"DOC_ECR_FORM"."ECR_APPRVL_COMMENT" AS "ECR_APPRVL_COMMENT",
"SH_JOB_DESCRIPTION"."JOB_DESC" AS "JOB_DESC",
"SH_EMPLOYEES"."USER_NAME" AS "USER_NAME"
    
 from     "DOC_ECR_FORM" "DOC_ECR_FORM",
          "SH_EMPLOYEES" "SH_EMPLOYEES",
          "SH_JOB_DESCRIPTION" "SH_JOB_DESCRIPTION"

 where   "DOC_ECR_FORM"."JOB_DESC_ID"="SH_JOB_DESCRIPTION"."JOB_DESC_ID" 
    and     "SH_JOB_DESCRIPTION"."JOB_DESC_ID"="SH_EMPLOYEES"."JOB_DESC_ID"

*ADDITION*
WHERE "USER_NAME" = :P101_USERNAME
and :P101_USERNAME <> 'SH_LOCAL'
and ((UPPER("REQUEST_APPRVL") = 'YES' and "APPROVED" IS NULL)
 or (UPPER("REQUEST_APPRVL")= 'YES' and UPPER("APPROVED") = 'NO')
 or (UPPER("REQUEST_APPRVL") = 'YES' and UPPER("APPROVED") = 'RE-APPROVAL REQUIRED'))

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 22 2011

Added on Aug 23 2011

#apex, #apex-discussions, #form, #of, #sql

10 comments

12,498 views