Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> INSERT..INTO...SELECT and LONG datatypes

INSERT..INTO...SELECT and LONG datatypes

From: Klaus Lassak <lassak_at_micom-medicare.de>
Date: 1998/05/18
Message-ID: <355fdfd7.0@news.t-ware.de>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US