simple Stored procedure with drop, create table instruction...???

I'd like to create a stored procedure looking like that:

CREATE PROCEDURE provToOper
AS BEGIN DROP sequence fs_ssis2_oper.COMPANY_SEQ; CREATE TABLE fs_ssis2_oper.COMPANY AS (SELECT * FROM fs_ssis2_prov.COMPANY);

END; But i always get an error message:

PLS-00103: Encountered the symbol "DROP" when expecting one of the foll...

(could not read what it is expecting... It would have been to easy ;-))

Any Idea?? Received on Thu Jul 01 1999 - 09:17:13 CDT