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: CREATE TABLE in stored procedure

Re: CREATE TABLE in stored procedure

From: Steffen Stellwag <Steffen.Stellwag_at_pcm.bosch.de>
Date: 1998/12/09
Message-ID: <366E74FA.55FA@pcm.bosch.de>#1/1

Sven Heins wrote:
>
> Hi,
>
> I'd like to create a table in a package or stored procedure with dynamic
> SQL using DBMS_SQL package.
>
> Problem:
> I have rights to create a table and I can use the coding in an anonymous
> PL/SQL block (with the same USER connected to the database) but I can't
> execute a procedure with this coding successfully.
> The owner of the procedure is the same USER and the execution of the
> procedure is made with this USER but I have still right problems!!!
>
> What is wrong???
>
>
Received on Wed Dec 09 1998 - 00:00:00 CST

Original text of this message

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