Re: create sequence in procedure / privileges ?
From: ddf <oratune_at_msn.com>
Date: Fri, 2 Jan 2009 05:30:33 -0800 (PST)
Message-ID: <5f3461a4-9340-4fa1-bf4a-7298f0d0cd13_at_p29g2000vbn.googlegroups.com>
On Jan 2, 4:10 am, "timo" <timo.ta..._at_luukku.com> wrote:
> Hi,
> I'm facing problems when creating sequences in a stored procedure.
> Seqs are beeing created with dymanic pl/sql and eevrything should be fine -
> but still seqs are beeing dropped but not created or altered - this must be
> up to privileges ???
> If so, what privs there should be in a case like this ?
> BR,
> Timo
Date: Fri, 2 Jan 2009 05:30:33 -0800 (PST)
Message-ID: <5f3461a4-9340-4fa1-bf4a-7298f0d0cd13_at_p29g2000vbn.googlegroups.com>
On Jan 2, 4:10 am, "timo" <timo.ta..._at_luukku.com> wrote:
> Hi,
> I'm facing problems when creating sequences in a stored procedure.
> Seqs are beeing created with dymanic pl/sql and eevrything should be fine -
> but still seqs are beeing dropped but not created or altered - this must be
> up to privileges ???
> If so, what privs there should be in a case like this ?
> BR,
> Timo
My question is:
Why are you using dynamic SQL to create sequences inside a procedure? What business requirement necessitates this?
David Fitzjarrell Received on Fri Jan 02 2009 - 07:30:33 CST