| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.misc -> insufficient privilege to create temp table from stored proc
I am trying to create a temporary table, which works fine in SQL-PLUS, but
gives me an insufficient privilege error when run as below in a stored
procedure.
Any idea what privilege I'm missing. I've been going round and round int he
help for about half an hour.
Thanks,
Jon
PROCEDURE create_temp_tables IS
BEGIN
execute immediate 'create GLOBAL TEMPORARY table temp_client
 (id decimal(15),  sin int,  dob date,  sex char(1),  fil int,role
char(2),age int,realdob int)';
END;
Received on Mon Feb 11 2002 - 10:10:45 CST
![]()  | 
![]()  |