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 -> Re: Copy inside EXECUTE IMMEDIATE

Re: Copy inside EXECUTE IMMEDIATE

From: Peter Sylvester <peters_no_spam_please_at_mitre.org>
Date: Wed, 16 Jun 2004 14:29:44 -0400
Message-ID: <caq3io$r22$1@newslocal.mitre.org>


"Copy" is a sql*plus internal command.

--Peter

Roy wrote:
> 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:29:44 CDT

Original text of this message

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