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
