OraFAQ Forum: SQL & PL/SQL » Create table in stored procedure

Home » SQL & PL/SQL » SQL & PL/SQL » Create table in stored procedure

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Create table in stored procedure [message #350]

Wed, 06 February 2002 09:46

LI810
Messages: 25
Registered: February 2002

Junior Member

Please help. What is wrong with this statements. When I try to create proc, I got an error message , saying, that "create" is used in a wrong space. Expecting "declare", "begin" etc.

CREATE OR REPLACE PROCEDURE test1
is

begin

CREATE TABLE temptable

(tbl_name varchar2(50),
rowcount number(12));

INSERT INTO temptable
select tbl_nme_x as Table_name,avg(row_count)as AVG_count
from CSCADMIN.TABLE_REC_AUDIT
group by tbl_nme_x;

end;

Report message to a moderator