Re: insufficient privilege to create temp table from stored proc

1. You need the CREATE ANY TABLE priviledge granted directly to you and not via a role for it to work in Dynamis SQL
2. It will probably fail anyway since there is no datatype of int or decimal in Oracle. Use Number for those and VARCHAR2(1) instead of CHAR.

"Jon Waterhouse" <jonwaterhouse_at_mail.gov.nf.ca> wrote in message news:<3c67ecb8.0_at_209.128.1.3>...
> 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 Tue Feb 12 2002 - 10:17:39 CST