Can't create table in procedure

From: <sw_at_weinerfamily.org>
Date: Wed, 29 Nov 2000 21:32:47 GMT
Message-ID: <3A2575D9.CCDDF34C_at_weinerfamily.org>


I don't know PL/SQL well. Can you tell me why this doesn't work? Is there a problem creating tables in procedures?

CREATE OR REPLACE
PROCEDURE x AS
BEGIN
 CREATE TABLE XX
   AS SELECT * FROM transaction where transaction_id < 500 END; The error states it didn't expect CREATE Received on Wed Nov 29 2000 - 22:32:47 CET

Original text of this message