ch 4 error w/ category table

tovachanah · July 20th, 2009, 06:09 PM

ORA-20505: Error in DML: p_rowid=1, p_alt_rowid=CATEGORY_ID, p_rowid2=, p_alt_rowid2=. ORA-04098: trigger 'CIS2616HERSCHFUS.T_CATEGORY_' is invalid and failed re-validation

Unable to process row of table CATEGORY.

what is wrong here

this is on page 114

i can't get this to update

peace95 · July 20th, 2009, 09:27 PM

Tovachanah:
On page 114, one is adding the categories table to the Maintenance tab. The error states, to me the Categories table does not exist. Starting on page 73 #5, @ bottom of page, is the beginning of creating the Categories table. Updates foir the Category table is on the pages:

#6-#9, page 74;
#1 - #3, p.75. Although #1 instructs u to use the Product Form. Follow instructions explicidly;
#4 - #10, p. 77;
Follow How It Works,pp. 78 - 80. Within #4 -#7, references the Category table and #10, p. 80 references Category, but after #9.

Hope this helps.

tovachanah · July 22nd, 2009, 03:23 PM

Quote:

Originally Posted by peace95

Tovachanah:
On page 114, one is adding the categories table to the Maintenance tab. The error states, to me the Categories table does not exist. Starting on page 73 #5, @ bottom of page, is the beginning of creating the Categories table. Updates foir the Category table is on the pages:

#6-#9, page 74;
#1 - #3, p.75. Although #1 instructs u to use the Product Form. Follow instructions explicidly;
#4 - #10, p. 77;
Follow How It Works,pp. 78 - 80. Within #4 -#7, references the Category table and #10, p. 80 references Category, but after #9.

Hope this helps.

the category table does exist... i didn't call it categories like in the book..i called it category...but it does exist and it does have data