Plez help attaching sequence to form object..

[Quoted] Thanks for reading this.

[Quoted] I have a Forms5.0 / Oracle 8.0.5 database running on Win NT 4.0.

I have a sequence called CR_SEQ. When I try to attach the sequence to a form field (a text field) I either get a compile error or a run-time error based on what I try.

When I try....

   select :block_name.CR_SEQ.nextval into change_request.cr_number;

I get a compile error.

I've tried...   

    :block_name.CR_SEQ.nectval

    'block_name.CR_SEQ.next_val'

     block_name.CR_SEQ.nextval

     :SEQUENCE.CR_SEQ.nextval

etc, etc, etc....

So, please tell me how to correctly specify my sequence.

[Quoted] Also, is there any special role or priv I have to grant users for this sequence to work right?

Thanks,
Richard Hollingsworth Received on Mon Jun 19 2000 - 00:00:00 CEST