SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ora-01031 insufficient privileges error

463428Jul 16 2007 — edited Jul 16 2007

Hi all,

I am getting this ora-01031 insufficient privileges error while increament sequence
in the block(procedure)

but when i execute
SELECT brch_seq.nextval /*INTO BSEQ */ FROM DUAL;
I am getting sequence number; but the same in proc is giving above err...
what might have went wrong.

kindly help.
Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 13 2007

Added on Jul 16 2007

3 comments

1,184 views