Skip to Main Content
Forums

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!

Common use of Sequence in Package

584260May 16 2009 — edited May 25 2009
Hi,

I need to get the NEXTVAL from a sequence and i have to pass that to many packages inside of a package.

If i write SELECT seq.nexval into v_varil from dual; means the value wont change sequentially.


How can i get the NEXTVAL sequentialy and declare the SELECT stmt commonly.


Can anyone help me in this.




Thanks
Radha K
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 22 2009
Added on May 16 2009
9 comments
1,485 views