Re: create sequence in procedure / privileges ? - solved
From: timo <timo.talja_at_luukku.com>
Date: Fri, 02 Jan 2009 10:54:14 GMT
Message-ID: <qnm7l.46$5A1.27_at_read4.inet.fi>
Hmmm,
just found an extra-';' from dymanic sql - that was causing this mess... Sorry...
BR;
Timo
"timo" <timo.talja_at_luukku.com> wrote in message news:wKl7l.41$5A1.34_at_read4.inet.fi...
> 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
>
Received on Fri Jan 02 2009 - 04:54:14 CST
Date: Fri, 02 Jan 2009 10:54:14 GMT
Message-ID: <qnm7l.46$5A1.27_at_read4.inet.fi>
Hmmm,
just found an extra-';' from dymanic sql - that was causing this mess... Sorry...
BR;
Timo
"timo" <timo.talja_at_luukku.com> wrote in message news:wKl7l.41$5A1.34_at_read4.inet.fi...
> 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
>
Received on Fri Jan 02 2009 - 04:54:14 CST