SP2-0042: unknown command "end" - rest of line ignored.
988562May 7 2013 — edited May 8 2013Hi 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;