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>
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
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