Oracle DB ORA-01722: invalid number error

I was getting a ORA-01722: invalid number error with the following code:


BigDecimal sequence = 1000595201
db.execute "alter sequence snp_calls_seq increment by ${sequence}"

Instead use :


BigDecimal sequence = 1000595201
String str = "alter sequence snp_calls_seq increment by ${sequence}"
db.execute str

Why ?

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s