Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Can't create table in procedure

Can't create table in procedure

From: <sw_at_weinerfamily.org>
Date: Wed, 29 Nov 2000 21:32:47 GMT
Message-ID: <3A2575D9.CCDDF34C@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 - 15:32:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US