pb with sequence

Hi everybody,

I'm a newbie with PL/SQL and Oracle. I use Oracle 7.3 on a Windows NT workstation. I try to use a sequence for a primary key. I thought it was as simple as :
create sequence mysequence;

and then to use it to insert a new row:
insert into oneofmytable values (mysequence.NEXTVAL, x1, ..... xn);

oneofmytable is obviously already created and is empty ! But this doesn't work ! If anybody has any clue, thanks in advance!

• Romuald JOUFFREY - TIMC IMAG Email : Romuald.Jouffrey_at_imag.fr *
• Faculte de medecine de Grenoble http://www-cami.imag.fr/~jouffrey/ *
• 38706 LA TRONCHE CEDEX FRANCE Tel (33)0476637139 FAX (33)0476518667*
• Numero de Kobby 0669151214 Par Minitel 0836097070/609090 operatrice *

  ---