This discussion is archived
1 Reply Latest reply: May 8, 2013 4:38 AM by mkirtley-Oracle RSS

SP2-0042: unknown command "end" - rest of line ignored.

988562 Newbie
Currently Being Moderated
Hi All, below is my code..

set timing on
begin
Delete PB_SURVEY_USER_IMA where Name != 'Login ID';
Delete PB_SURVEY_USER_IMA where value not like '%@%';
#Delete PB_SURVEY_USER_IMA where lower(value) like lower('%@pb.com');
Update PB_SURVEY_USER_IMA
Set Id = 10557,
CAN = (      Select Max( account_number)
          from pbaccount
          where member_id in (
               Select users_id
               from userreg
               where userreg.logonid = trim(PB_SURVEY_USER_IMA.value))
);
commit;
Update PB_SURVEY_USER_IMA Set country_id=(Select language_id from users where users_id in (Select users_id from userreg where userreg.logonid = trim(PB_SURVEY_USER_IMA.value)));
commit;
end;
/
exit;

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points