Newbie Oracle SQL Plus question

[shyamal]

I am new to Oracle and SQL Plus. I cannot get the basic commands to work.

I tried to execute the following:
insert into dev.SLEONTPS (FLDNUMB1) values (1);
and returned
ERROR at line 1:
ORA-00904: invalid column name

My columm name is correct. This is what the table looks like
Name Schema Datatype Size Scale Ref Nulls
<FLDNUMB1> <NONE> NUMBER 10 0
<FLDNUMB2> <NONE> NUMBER 5 0
..

What am I doing wrong?
Thanks in advance.

 

[rcurva]

Make sure you have the appropriate object privileges granted like INSERT priv.

As DEV user issue the following;

GRANT INSERT ON dev.SLEONTPS TO <user>;

After that, try again your insert.