Toad World® Forums

Create sequence problem


#1

Hi

This is a very strange problem.

1- start a session
2- in SQL Script write
CREATE SEQUENCE g

3- it gets ORA-02277: invalid sequence name
even if you select all the line

using the SQL tracker I found out that SQL is only sending “CREATE SEQUENCE”

but If I write
CREATE SEQUENCE g;
or
CREATE SEQUENCE g
/
it works


#2

Hi Filipe,

It seems there’s an error with the parser that terminates the CREATE SEQUENCE statement incorrectly. I have create a CR to fix it.

Thanks,
Vincent


#3

fixed at least in beta 6.4.0.1913