Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Restrictions on using commands in Stored Procedures

Re: Restrictions on using commands in Stored Procedures

From: Gocha Mchedlishvili <gocham_at_mci2000.com>
Date: Wed, 29 Jul 1998 23:35:01 GMT
Message-ID: <FkOv1.3147$__4.775381@news.mci2000.com>


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 Wed Jul 29 1998 - 18:35:01 CDT

Original text of this message

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