Procedure problems

Hi

Im attempting to run a procedure using an outside program (MapInfo), however i dont seem to be able to successully compile the procedure:

begin

   execute immediate 'create or replace view Operators as Select * from hr.status5 where operator = 'PFS' and branchNo > 1000';

end;

Im getting the error at PFS but being fairly new to this, cant see what is wrong with the syntax.

Thanks for any help.
Paul Received on Tue May 09 2006 - 06:49:28 CDT