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

Home -> Community -> Usenet -> c.d.o.server -> Copy inside EXECUTE IMMEDIATE

Copy inside EXECUTE IMMEDIATE

From: Roy <roee7_at_yahoo.com>
Date: 16 Jun 2004 11:22:12 -0700
Message-ID: <d6f54e4d.0406160916.43e42a16@posting.google.com>


DECLARE
sql_txt VARCHAR2(200);
BEGIN
sql_txt:= 'COPY FROM AA/AA_at_AA TO BB/BB_at_BB REPLACE T1 USING SELECT * FROM T1;';
EXECUTE IMMEDIATE sql_txt;
END;
/

ORA-00900: invalid SQL statement
ORA-06512: at line 5

When I use the copy command without EXECUTE IMMEDIATE it works fine, but with EXECUTE IMMEDIATE I get the errors. What is wrong and how can I fix it? Received on Wed Jun 16 2004 - 13:22:12 CDT

Original text of this message

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