OraFAQ Forum: Forms » call sequence from forms

Home » Developer & Programmer » Forms » call sequence from forms

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

call sequence from forms [message #162996]

Tue, 14 March 2006 08:58

eswaries
Messages: 41
Registered: January 2006

Member

Sequence from forms error:

I create a sequence.

I am working in oracle8 and

Forms [32 Bit] Version 6.0.8.8.0 (Production)

SQL> create sequence billno start with 1000;

Sequence created.

SQL> select billno.nextval from dual;

NEXTVAL
---------
1000

I called this sequence from the form. Under the push_button ,when_button_pressed trigger,I write this query but it creates a error under this query,

SELECT billno.NEXTVAL INTO :billno from dual;

Error 201 at line1 ,Column41
Identifier ‘DUAL’ must be declared
Error 0 at line1 column1
sql Statement ignored

Report message to a moderator