Re: Restrictions on using commands in Stored Procedures

You can do this, as well as other ddl by using the dbms_sql package.

Make sure that the owner of the SP has create user priviledges

Gocha Mchedlishvili wrote:

> I'm trying to use
> CREATE USER inside of SP.
>
> Thanks
> Gocha
>
> Param wrote in message <35BEC2DB.3A9DF3CF_at_citicorp.com>...
> >Gocha Mchedlishvili wrote:
> >>
> >> Hi!
> >> Is there any site in Internet or maybe anybody knows what are the
> >> restrictions on using commands in Stored Procedures?
> >>
> >> I mean, which commands I can't use in SP?
> >>
> >> Thanks
> >>
> >> Gocha
> >
> >Gocha,
> >
> >You can use whatever the PLSQL manual says you can. You cannot use DDL
> >statements. (You can use them using Dynamic SQL.)
> >
> >Any particular command which is giving you problems?
> >
> >Regards,
> >Param
Received on Thu Aug 27 1998 - 20:53:07 CDT