RE: COPY command inside of stored procedure

COPY is a sqlplus only tool. You will have to create your own for use in a stored proc.

HTH
Shawn M Ferris
Oracle DBA - Time Warner Telecom

> -----Original Message-----
> From: Cale, Rick T (Richard) [mailto:RICHARD.T.CALE_at_saic.com]
> Sent: Thursday, December 07, 2000 9:04 AM
> To: ORACLE-L_at_fatcity.com; oracledba_at_quickdoc.co.uk
> Subject: COPY command inside of stored procedure
>
>
> Hi DBAs,
>
> Does any have an example of using the COPY command in stored
> procedure. I
> have one that works
> ok in sql plus it works. However when I try to put it in a
> store procedure
> both as regular sql or
> using dbms_sql I get invalid sql statement although it works
> outside of
> stored procedure.
>
> Thanks
> Rick Cale, Science Applications International Corp.
> Phone:865-481-2198, fax:865-481-8555
> e-mail: caler_at_saic.com
>
>
> --------
> Think you know someone who can answer the above question?
> Forward it to them!
> to unsubscribe, send a blank email to
> oracledba-unsubscribe_at_LAZYDBA.com
> to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com
> Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Received on Thu Dec 07 2000 - 10:06:15 CST