Re: Plez help attaching sequence to form object..

Hi,

try this:

SELECT CT_SEQ.Nextval
INTO :BlockName.ItemName
FROM DUAL;
> Also, is there any special role or priv I have to grant users for this
> sequence to work right?

GRANT SELECT ANY SEQUENCE TO <user>

Hth
Markus

Richard Hollingsworth <william.hollingsworth_at_hsv.boeing.com> schrieb in im Newsbeitrag: 394E87F1.E06F81FC_at_hsv.boeing.com...
> Thanks for reading this.
>
> 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.
>
> Also, is there any special role or priv I have to grant users for this
> sequence to work right?
>
> Thanks,
> Richard Hollingsworth
Received on Tue Jun 20 2000 - 00:00:00 CEST