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

Home -> Community -> Usenet -> c.d.o.misc -> Re: insufficient privilege to create temp table from stored proc

Re: insufficient privilege to create temp table from stored proc

From: MarkyG <markg_at_mymail.tm>
Date: 12 Feb 2002 08:17:39 -0800
Message-ID: <ab87195e.0202120817.6b26ddbc@posting.google.com>

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

"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

Original text of this message

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