HELP INSERTING BLOB / orc7 !!!

Under Oracle 7 I have two tables:

Table A:
tbla_id ,
tbla_blob

Table B:
tblb_id,
tblb_blob

Table A is empty.
Now I required to insert the rows (including BLOBs) from table b in table a.

When trying to insert with the "standard" statement (insert into tbla(tbla_id, tbla_blob) select tblb_id, tblb_blob from tblb ) there occurs the
error "ORA-00997".

What are the correct statement to do this?

Thanks for your help
Frank Received on Mon May 11 1998 - 07:40:21 CDT