INSERT..INTO...SELECT and LONG datatypes

anybody can help, I have the problem in a PL/SQL procedure while moving records beween two tables containing a LONG datatypes.

My idea was to submit a INSERT..INTO...SELECT statement like this (dl_dummy is a database link):

(...)

v_cursorid := DBMS_SQL.OPEN_CURSOR;
v_statement := 'INSERT INTO table1_at_dl_dummy SELECT * from table1 WHERE ID = :M';
DBMS_SQl.PARSE(v_cursorid, v_statement, DBMS_SQL.V7); DBMS_SQL.BIND_VARIABLE(v_cursorid, ':M',p_id); v_ok := DBMS_SQL.EXECUTE(v_cursorid);
(...)

When executing this procedure I get an ORA-00997 The problem is that LONG datatypes do not work with INSERT..INTO...SELECT statements.

any suggestions ?
many thanx

Klaus Received on Fri May 15 1998 - 00:00:00 CDT