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: stored procedures / ora-01031

Re: stored procedures / ora-01031

From: Philippe <parnaud_at_yahoo.com>
Date: 29 Jul 1998 12:45:57 GMT
Message-ID: <01bdbaee$5362f960$2a822c95@pdcpm>


You have to grant "CREATE TABLE" privilege to the procedure owner. A stored procedure use the owner privileges, not the user privileges.

Arnold Schommer <aschommer_at_fs-edv.de> wrote in article <35BF03D8.F202B33_at_fs-edv.de>...
> I have encountered the following strange situation: In order to rebuild
> an table chosen by the user i used dynamic SQL via some own package
> calling the DBMS_SQL-Package; the instruction was something like
> CREATE TABLE schema.save_example AS (SELECT * FROM schema.example)
> (please don't focus on the schema and table names)
> Doing it this way i got the error ora-01031 on DBMS_SQL.PARSE(). Copying
> the SQL-instruction to SQL-worksheet, it worked. The same instruction
> performed via FORMS_DDL() also succeeded.
>
> The Login was the same for Forms and SQL-worksheet, so what is the
> reason of this different behaviour ? Did i do something wrong ?
>
> I'm using Oracle Forms 4.5, the Database-Version is 7.3.2.2.0 (on NT).
>
> Thanks in advance
>
> Arnold
>
Received on Wed Jul 29 1998 - 07:45:57 CDT

Original text of this message

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