CODEWITHSUNDEEP
sqlplsql
praveen
praveen

Reputation: 27

PL/SQL: ORA-00905: missing keyword in update statement

UPDATE XXBBBY_WEEK_DATA_CNV_STG 
SET
process_status = CASE 
WHEN error1 = 'No week data Details found' THEN 'E',last_update_time=sysdate
WHEN error1 = 'Processed successfully' THEN 'P'
WHERE  process_status = 'N';

Line/Col: 1/1 PL/SQL: SQL Statement ignored Line/Col: 6/5 PL/SQL: ORA-00905: missing keyword

Upvotes: 0

Views: 211

Answers (1)

Tim Biegeleisen
Tim Biegeleisen

Reputation: 521609

You need to END your CASE expressions, and also the current logic seems to be out place here and there:

UPDATE XXBBBY_WEEK_DATA_CNV_STG 
SET process_status = CASE error1 WHEN 'No week data Details found' THEN 'E'
                                 WHEN 'Processed successfully' THEN 'P' END,
    last_update_time = sysdate
WHERE process_status = 'N';

Upvotes: 2

Related Questions