Re: EXECUTE IMMEDIATE & COPY FROM

"Robert Rainville" <[email protected]> Tue, 8 Apr 2003 11:42:40 -0400

Newsgroups	gmane.comp.db.oracle.devel
Message-ID	<LYRIS-1796914-944279-2003.04.08-16.39.10--gcdod-oracle#[email protected]>

COPY FROM is a SQL*Plus command=20
not a SQL command
Only SQL*Plus will recognize it
Therefore it cannot be used in PL/SQL blocks which are interpreted in
the database not by SQL*Plus

-----Original Message-----
From: THEODORE PAPADOPOULOS [mailto:[email protected]]=20
Sent: Tuesday, April 08, 2003 11:39 AM
To: Oracle
Subject: [oracle] Re: EXECUTE IMMEDIATE & COPY FROM


apparently i use the  next line=20
--l_str_sql:=3D'COPY FROM '|| SOURCE_USERNAME || '/'|| SOURCE_PASSWORD=20
|> | '@'|| SOURCE_DBNAME|| '  INSERT '|| l_str_table_ ...........


without the comments.

---
Change your mail options at http://p2p.wrox.com/manager.asp or=20
to unsubscribe send a blank email to %%email.unsub%%.

---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].