Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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 Mon May 18 1998 - 00:00:00 CDT
![]() |
![]() |