Re: stored procedures / ora-01031

(please pardon the late response)

Philippe wrote:

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

That can not be the reason - in the particular case, the procedure owner and user were the same. (And both were allowed to create tables).

> 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 Mon Aug 03 1998 - 04:41:19 CDT