why wont this work?

[bookouri]

I put this code in the when-button-pressed event of a button on my form, I want it to get the nextval and plug it into the gc_block.idnumber - or the idnumber field in the table actually,
My select statement works find in test, but in the form I get an error - component nextval must be declared... this seems very simple but I can NOT make it work... any help would be appreciated...

declare

temp number(12);

begin

select gc_id.nextval into temp from dual;

:gc_block.idnumber := temp;

do_key('commit_form');

end;

 

[sem]

Are you connected to Oracle when compiling this code?
Do you have access to gc_id sequence if it isn't in your schema?
Are there any objects other then sequence in your schema with the same name?