drop and create sequence from a stored procedure
Hi
I'm trying to drop and create a sequence from a stored procedure vut I get:
PLS-00103: Encountered the symbol "DROP" when expecting one of the following:
begin function package pragma procedure subtype type use
for
I have the permissions to do it outside the stored procedure.
is there a special place on the procedure I should put it?
Thanks
Re: drop and create sequence from a stored procedure
Quote:
Originally posted by liorjsb
I have the permissions to do it outside the stored procedure.
For inside a stored procedure, make sure that you have the
permission directly granted to you, not just based on role.