Re: Copy inside EXECUTE IMMEDIATE

Thanks so much, that explains it. I should not use sql*plus internal commands inside Execute Immediate, I should use CREATE TABLE instead.

Roy.

Peter Sylvester <peters_no_spam_please_at_mitre.org> wrote in message news:<caq3io$r22$1_at_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 Thu Jun 17 2004 - 13:02:12 CDT