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!

create sequence with sql plus variable for maxvalue

1932140Dec 6 2017 — edited Dec 7 2017

I'm trying to create a sequence using a sql plus variable to define the maximum value, but I get the following exception:

SQL> undefine maxminute

variable maxminute number

exec :maxminute := 1440;

begin

execute immediate 'create sequence a_seq increment by 1 maxvalue :1 start with 1 cycle'

using :maxminute;

end;

/SQL> SQL>

PL/SQL procedure successfully completed.

SQL> SQL> 2 3 4 5

begin

ERROR at line 1:

ORA-01722: invalid number

ORA-06512: at line 2

Can anybody help with this ?

This post has been answered by Solomon Yakobson on Dec 6 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 3 2018

Added on Dec 6 2017

6 comments

621 views