Thank you guys for your help. It works now!

----- Original Message -----
From: "Vijaya Sawant" <[Email Address Removed] <[Email Address Removed] Friday, November 28, 2003 9:52 PM
Subject: Re: ORA-01031 and ORA-06512


> Do the user has execute privilege to execute this procedure?
>
> >>> "John" <[Email Address Removed] 11/28/2003 2:46:05 PM >>>
> I have the following errors when i try to create a user via a
> procedure
>
> ORA-01031: insufficient privileges
> ORA-06512: at "SYS.DBMS_SYS_SQL", line 826
> ORA-06512: at "SYS.DBMS_SQL", line 32
> ORA-06512: at "TOM.P_NEW_USER", line 6
> ORA-06512: at line 1
>
>
> The line 6 points to DBMS_SQL.PARSE()
>
>
> Do you know how to solve it?
>
> I use Oracle 9i R2
>

Oracle LazyDBA home page