If you want to execute multiple SQL statements at once you have to pass it as PL/SQL in an anonymous PL/SQL Block by surrounding the statements with a begin / end pair:
Code
begin
Insert into LostApplicants ( Cycle_Year, Applicant_ID, Applicant_SSN )'
values ( :CYCLEYEAR, :APPLICANTID, :APPLICANTSSN );
Commit;
Update Temp_d
Set Visible = 0
Where Temp_d.Applicant_ID = :APPLICANTID;
Commit;
end;
The invalid character that Oracle complains about is the semi-colon at the end of the first statement.
