Reg:Creating Sequence

[Former Member]

hi

can you anyone please tell me how to create sequence in xmii suppose if i use syntax like this

CREATE SEQUENCE supplier_seq

MINVALUE 1

MAXVALUE 999999999999999999999999999

START WITH 1

INCREMENT BY 1

CACHE 20;

its showing an error

<b>A SQL Error has occurred on query, ORA-00911: invalid character

Thanks in advance

[richard_howard · Accepted solution]

This also applies to Visual Administrator when you are defining a DataSource with a JDBC Driver.

Services > JDBC Connector > DataSource > DB Initialization

If you enter a SQL Statement to test the connection of your new Data Source, DO NOT use a semi-colon at the end. If you do, you'll get the ORA-00911 error.

[Former Member]

I got the answer

[Former Member]

Could you share the answer with us??

[Former Member]

Hi Praveen,

This is the syntax for creating a Sequence

CREATE SEQUENCE Seq_Name

START WITH 1000

INCREMENT BY 5

i have choosed mode as a Command

[Former Member]

Hi DevaKrishnan,

u can use the same as used first , that is

CREATE SEQUENCE supplier_seq

MINVALUE 1

MAXVALUE 999999999999999999999999999

START WITH 1

INCREMENT BY 1

CACHE 20

and choosing the same mode(command) the only difference is remove the semicolon then it works fine.

Regards,

chaitanya