topic Re: sql insert error: column not allowed here in Operating System - HP-UX

sql insert error: column not allowed here

Ratzie — Mon, 16 Jan 2006 11:54:29 GMT

I am trying to do a load of one column. Into a primary key.

cat TID.txt|while read i
do echo $i
sqlplus -s $LOGONID <insert into tid_tbl ( TID )
values($i);
commit;
quit

EOF
done

I get column not allowed here.
For the TID column.

Re: sql insert error: column not allowed here

Oviwan — Mon, 16 Jan 2006 12:00:39 GMT

Hi

try this:
insert into tid_tbl ("TID")
values($i);

the error# is:
ORA-00984:column not allowed here

first try the statements in SQL*Plus or whatever you use.

Regards

Re: sql insert error: column not allowed here

Patti Johnson — Mon, 16 Jan 2006 12:02:19 GMT

What is the datatype for TID.

If it is character data then you need to enclose the $i in quotes. Try this.

cat TID.txt|while read i
do echo $i
sqlplus -s $LOGONID <insert into tid_tbl ( TID )
values('$i');
commit;
quit

EOF
done

Patti

Re: sql insert error: column not allowed here

Ratzie — Mon, 16 Jan 2006 12:08:14 GMT

I have tried both ways and still get same error.

Re: sql insert error: column not allowed here

Patti Johnson — Mon, 16 Jan 2006 12:32:51 GMT

Please post a describe of the table and the input file.

I ran your original script with a varchar2 column and got this error.
d
values(d)
*
ERROR at line 2:
ORA-00984: column not allowed here

But when I added the '' it worked.
It treats the $i as a column name without the quote.

Please post the output of your run.

Patti

Re: sql insert error: column not allowed here

Ratzie — Mon, 16 Jan 2006 14:19:50 GMT

You are correct, insert worked correctly with ' '
I had a typo with the '

Re: sql insert error: column not allowed here

Ratzie — Mon, 16 Jan 2006 14:20:07 GMT

Thanks Patti