1 Reply Latest reply: May 8, 2013 6:38 AM by Mkirtley-Oracle RSS

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

    988562
      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;